Re: [HACKERS] INSERT INTO arr2(array[1].d, array[2].d)

2017-03-11 Thread Andres Freund
On 2017-03-11 14:43:55 -0600, Jim Nasby wrote: > Over in [1], I was very surprised to discover $SUBJECT[2]. I looked in the > docs, and they clearly indicate that INSERT accepts "column names". They also say "The column name can be qualified with a subfield name or array subscript, if needed." >

[HACKERS] INSERT INTO arr2(array[1].d, array[2].d)

2017-03-11 Thread Jim Nasby
Over in [1], I was very surprised to discover $SUBJECT[2]. I looked in the docs, and they clearly indicate that INSERT accepts "column names". What's the best way to describe this? "column expression"? "field expression"? 1: https://www.postgresql.org/message-id/20170311005810.kuccp7t5t5jhe.