mirror of
https://github.com/pgvector/pgvector.git
synced 2026-06-06 14:01:31 +08:00
120 lines
3.0 KiB
Plaintext
120 lines
3.0 KiB
Plaintext
SELECT '[1,2,3]'::intvec;
|
|
intvec
|
|
---------
|
|
[1,2,3]
|
|
(1 row)
|
|
|
|
SELECT '[-1,-2,-3]'::intvec;
|
|
intvec
|
|
------------
|
|
[-1,-2,-3]
|
|
(1 row)
|
|
|
|
SELECT ' [ 1, 2 , 3 ] '::intvec;
|
|
intvec
|
|
---------
|
|
[1,2,3]
|
|
(1 row)
|
|
|
|
SELECT '[1.23456]'::intvec;
|
|
ERROR: invalid input syntax for type intvec: "[1.23456]"
|
|
LINE 1: SELECT '[1.23456]'::intvec;
|
|
^
|
|
SELECT '[hello,1]'::intvec;
|
|
ERROR: invalid input syntax for type intvec: "[hello,1]"
|
|
LINE 1: SELECT '[hello,1]'::intvec;
|
|
^
|
|
SELECT '[127,-128]'::intvec;
|
|
intvec
|
|
------------
|
|
[127,-128]
|
|
(1 row)
|
|
|
|
SELECT '[128,-129]'::intvec;
|
|
ERROR: value "128" is out of range for type intvec
|
|
LINE 1: SELECT '[128,-129]'::intvec;
|
|
^
|
|
SELECT '[1,2,3'::intvec;
|
|
ERROR: malformed intvec literal: "[1,2,3"
|
|
LINE 1: SELECT '[1,2,3'::intvec;
|
|
^
|
|
DETAIL: Unexpected end of input.
|
|
SELECT '[1,2,3]9'::intvec;
|
|
ERROR: malformed intvec literal: "[1,2,3]9"
|
|
LINE 1: SELECT '[1,2,3]9'::intvec;
|
|
^
|
|
DETAIL: Junk after closing right brace.
|
|
SELECT '1,2,3'::intvec;
|
|
ERROR: malformed intvec literal: "1,2,3"
|
|
LINE 1: SELECT '1,2,3'::intvec;
|
|
^
|
|
DETAIL: Vector contents must start with "[".
|
|
SELECT ''::intvec;
|
|
ERROR: malformed intvec literal: ""
|
|
LINE 1: SELECT ''::intvec;
|
|
^
|
|
DETAIL: Vector contents must start with "[".
|
|
SELECT '['::intvec;
|
|
ERROR: malformed intvec literal: "["
|
|
LINE 1: SELECT '['::intvec;
|
|
^
|
|
DETAIL: Unexpected end of input.
|
|
SELECT '[,'::intvec;
|
|
ERROR: malformed intvec literal: "[,"
|
|
LINE 1: SELECT '[,'::intvec;
|
|
^
|
|
DETAIL: Unexpected end of input.
|
|
SELECT '[]'::intvec;
|
|
ERROR: intvec must have at least 1 dimension
|
|
LINE 1: SELECT '[]'::intvec;
|
|
^
|
|
SELECT '[1,]'::intvec;
|
|
ERROR: invalid input syntax for type intvec: "[1,]"
|
|
LINE 1: SELECT '[1,]'::intvec;
|
|
^
|
|
SELECT '[1a]'::intvec;
|
|
ERROR: invalid input syntax for type intvec: "[1a]"
|
|
LINE 1: SELECT '[1a]'::intvec;
|
|
^
|
|
SELECT '[1,,3]'::intvec;
|
|
ERROR: malformed intvec literal: "[1,,3]"
|
|
LINE 1: SELECT '[1,,3]'::intvec;
|
|
^
|
|
SELECT '[1, ,3]'::intvec;
|
|
ERROR: invalid input syntax for type intvec: "[1, ,3]"
|
|
LINE 1: SELECT '[1, ,3]'::intvec;
|
|
^
|
|
SELECT '[1,2,3]'::intvec(3);
|
|
intvec
|
|
---------
|
|
[1,2,3]
|
|
(1 row)
|
|
|
|
SELECT '[1,2,3]'::intvec(2);
|
|
ERROR: expected 2 dimensions, not 3
|
|
SELECT '[1,2,3]'::intvec(3, 2);
|
|
ERROR: invalid type modifier
|
|
LINE 1: SELECT '[1,2,3]'::intvec(3, 2);
|
|
^
|
|
SELECT '[1,2,3]'::intvec('a');
|
|
ERROR: invalid input syntax for type integer: "a"
|
|
LINE 1: SELECT '[1,2,3]'::intvec('a');
|
|
^
|
|
SELECT '[1,2,3]'::intvec(0);
|
|
ERROR: dimensions for type intvec must be at least 1
|
|
LINE 1: SELECT '[1,2,3]'::intvec(0);
|
|
^
|
|
SELECT '[1,2,3]'::intvec(16001);
|
|
ERROR: dimensions for type intvec cannot exceed 16000
|
|
LINE 1: SELECT '[1,2,3]'::intvec(16001);
|
|
^
|
|
SELECT unnest('{"[1,2,3]", "[4,5,6]"}'::intvec[]);
|
|
unnest
|
|
---------
|
|
[1,2,3]
|
|
[4,5,6]
|
|
(2 rows)
|
|
|
|
SELECT '{"[1,2,3]"}'::intvec(2)[];
|
|
ERROR: expected 2 dimensions, not 3
|