You've already forked pgvecto.rs
mirror of
https://github.com/tensorchord/pgvecto.rs.git
synced 2025-09-13 21:21:48 +03:00
39e8ee9797
* feat: mmap transport for macos Signed-off-by: usamoi <usamoi@outlook.com> * fix: building with feature pg12, pg13 Signed-off-by: usamoi <usamoi@outlook.com> * fix: call unlink for shmem Signed-off-by: usamoi <usamoi@outlook.com> * fix: reduce shmem filename on macos Signed-off-by: usamoi <usamoi@outlook.com> * chore: enable testing on all Postgresql versions Signed-off-by: usamoi <usamoi@outlook.com> * fix: use file instead of shmem for macos Signed-off-by: usamoi <usamoi@outlook.com> * chore: select simpler matrix for pull requests in CI Signed-off-by: usamoi <usamoi@outlook.com> * fix: remove macos-latest-16 Signed-off-by: usamoi <usamoi@outlook.com> * chore: reduce use of nightly features Signed-off-by: usamoi <usamoi@outlook.com> --------- Signed-off-by: usamoi <usamoi@outlook.com>
64 lines
899 B
Plaintext
64 lines
899 B
Plaintext
# basic + - = <> < <= > >=
|
|
query I
|
|
SELECT '[1,2.3,4e5]'::vector + '[6,7.8,9e10]';
|
|
----
|
|
[7, 10.1, 90000400000]
|
|
|
|
query I
|
|
SELECT '[1,2.3,4e5]'::vector - '[6,7.8,9e10]';
|
|
----
|
|
[-5, -5.5, -89999600000]
|
|
|
|
query I
|
|
SELECT '[1,2,3]'::vector = '[1,2,3]';
|
|
----
|
|
t
|
|
|
|
query I
|
|
SELECT '[1,2,3]'::vector <> '[1,2,3]';
|
|
----
|
|
f
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector < '[2,2]';
|
|
----
|
|
t
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector < '[1,3]';
|
|
----
|
|
t
|
|
|
|
statement error differs in dimensions
|
|
SELECT '[1,2]'::vector < '[1,2,3]';
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector <= '[2,2]';
|
|
----
|
|
t
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector > '[2,2]';
|
|
----
|
|
f
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector >= '[2,2]';
|
|
----
|
|
f
|
|
|
|
# basic <->(squared Euclidean distance) <#>(negative dot product distance) <=>(negative cosine distance)
|
|
query I
|
|
SELECT '[1,2]'::vector <-> '[3,4]';
|
|
----
|
|
8
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector <#> '[3,4]';
|
|
----
|
|
-11
|
|
|
|
query I
|
|
SELECT '[1,2]'::vector <=> '[3,4]' > -1;
|
|
----
|
|
t |