Re: WIP: default values for function parameters

2008/12/12 Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)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
>