3 ms·
> Still not sure if ARRAY['k'] is a thing, though. Yes it is. It's an alternative way of writing an array. Typically easier for e.g. text values as the quoting
by hans_castorp 5y ago
> Still not sure if ARRAY['k'] is a thing, though.
Yes it is. It's an alternative way of writing an array. Typically easier for e.g. text values as the quoting follows the normal SQL rules, e.g.
array['foo"bar', 'bla']
vs
'{"foo\"bar", "bar"}'