2008/12/12 Heikki Linnakangas <heikki.linnakangas@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
>