Array concatenation in Postgres is really simple, although the operator is non-obvious: ||<\/p>\n
This works for several syntactically similar combination of scalars and arrays, as seen here:<\/p>\n
\nselect ARRAY['b', 'c', 'd'] || ARRAY['e'];\nselect ARRAY['b', 'c', 'd'] || '{e}';\nselect '{a}' || ARRAY['b', 'c', 'd'];\nselect ARRAY['a'] || ARRAY['b', 'c', 'd'];\nselect array_cat('{a}'::text[], '{b,c,d}'::text[])\nselect 1 || ARRAY[2,3,4]\n<\/pre>\nIf you try scalar + array combinations with strings, you’ll get an error like so:<\/p>\n
\nERROR: array value must start with \"{\" or dimension information Position: 8\n<\/pre>\nThis is because Postgres doesn’t know whether or not to coerce a string you’ve provided into it’s array form. The only workaround I know for this is to make a single-element array from the value.<\/p>\n","protected":false},"excerpt":{"rendered":"
Array concatenation in Postgres is really simple, although the operator is non-obvious: || This works for several syntactically similar combination of scalars and arrays, as seen here: select ARRAY[‘b’, ‘c’, ‘d’] || ARRAY[‘e’]; select ARRAY[‘b’, ‘c’, ‘d’] || ‘{e}’; select ‘{a}’ || ARRAY[‘b’, ‘c’, ‘d’]; select ARRAY[‘a’] || ARRAY[‘b’, ‘c’, ‘d’]; select array_cat(‘{a}’::text[], ‘{b,c,d}’::text[]) select … <\/p>\n