SET client_min_messages = warning; CREATE EXTENSION IF NOT EXISTS vector; SELECT '[1,2,3]'::vector; vector --------- [1,2,3] (1 row) SELECT '[-1,2,3]'::vector; vector ---------- [-1,2,3] (1 row) SELECT '[hello,1]'::vector; ERROR: invalid input syntax for type vector: "hello" LINE 1: SELECT '[hello,1]'::vector; ^ SELECT '[NaN,1]'::vector; ERROR: NaN not allowed in vector LINE 1: SELECT '[NaN,1]'::vector; ^ SELECT '[Infinity,1]'::vector; ERROR: infinite value not allowed in vector LINE 1: SELECT '[Infinity,1]'::vector; ^ SELECT '[-Infinity,1]'::vector; ERROR: infinite value not allowed in vector LINE 1: SELECT '[-Infinity,1]'::vector; ^ SELECT '[1,2,3'::vector; ERROR: malformed vector literal LINE 1: SELECT '[1,2,3'::vector; ^ DETAIL: Unexpected end of input. SELECT '[1,2,3]9'::vector; ERROR: malformed vector literal LINE 1: SELECT '[1,2,3]9'::vector; ^ DETAIL: Junk after closing right brace. SELECT '1,2,3'::vector; ERROR: malformed vector literal: "1,2,3" LINE 1: SELECT '1,2,3'::vector; ^ DETAIL: Vector contents must start with "[". SELECT '[]'::vector; ERROR: vector must have at least 1 dimension LINE 1: SELECT '[]'::vector; ^ SELECT '[1,]'::vector; ERROR: invalid input syntax for type vector: "]" LINE 1: SELECT '[1,]'::vector; ^ SELECT '[1,2,3]'::vector(2); ERROR: expected 2 dimensions, not 3 SELECT unnest('{"[1,2,3]", "[4,5,6]"}'::vector[]); unnest --------- [1,2,3] [4,5,6] (2 rows) SELECT '{"[1,2,3]"}'::vector(2)[]; ERROR: expected 2 dimensions, not 3