2008/12/12 Heikki Linnakangas <heikki.linnakan...@enterprisedb.com>: > David E. Wheeler wrote: >> >> Coming to this a bit late, but it seems to me that, while it makes sense >> to assign a label to a value using "AS", it's kind of weird to use it to >> assign a value to a label. >> >> SELECT foo( bar => 'ick', baz => 'ack' ); >> SELECT foo( bar AS 'ick', baz AS 'ack' ); > > We could do it the other way round: > > SELECT foo( 'ick' AS bar, 'ack' AS baz); >
I discussed about this form with Tom. I thing so following should be readable: name: [ optional => ] value SELECT foo( bar: 'ick', baz: 'ack' ); SELECT foo( bar: => 'ick', baz: => 'ack' ); or SELECT foo( bar: = 'ick', baz: = 'ack' ); reason for optional using of "=>" is too thin char ":", so => optically boost the colon. Pavel this is 100% compatible because syntax name: is new token > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
