Hacker News Reader

Comment by quelltext | Hacker News Reader

What does ARRAY['k'] mean?

EDIT: Okay, so I looked up what {'k'} means, i.e. it's an array with one element 'k'. And in the article's function it's the "path" to the key to be set.

Still not sure if ARRAY['k'] is a thing, though. I could only find this sort of syntax described in the context of definition, e.g. ARRAY[4] for an array of length 4.

View on HN

> 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']

      '{"foo\"bar", "bar"}'

ARRAY[elem1, elem2, …] is a PostgreSQL array literal SQL expression.

Reply on news.ycombinator.com