Re: proposal sql: labeled function params - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal sql: labeled function params
Date
Msg-id 162867790808150631ofe63911x5d645cd86b9d8680@mail.gmail.com
Whole thread Raw
In response to Re: proposal sql: labeled function params  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Hello

2008/8/15 Peter Eisentraut <peter_e@gmx.net>:
> Am Friday, 15. August 2008 schrieb Tom Lane:
>> Hannu Krosing <hannu@2ndQuadrant.com> writes:
>> > How is this supposed to interact with argument names ?
>>
>> Yeah, the real problem with this proposal is that it conscripts a syntax
>> that we'll probably want to use in the future for argument-name-based
>> parameter matching.  The proposed behavior is not nearly as useful as
>> that would be.
>
> I am not at all convinced about the proposed feature, but is that really a
> syntax we would use for function calls with named parameters?
>
> Random googling shows me that Oracle appears to use a syntax like
>
>    name => value
>

I vote this syntax too. So this second feature - named params X labels
for params. Labels for params is related to my work on variadic
functions. Named params needs default param's values - and some more
of changes in parser. Somebody have to solve conflict between params
and expression.

Pavel




> This is actually a feature that I would like to see implemented soonish, so if
> anyone has input on the possible syntax consequences, please comment.
>


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: So what about XSLT?
Next
From: Tom Lane
Date:
Subject: Re: varchar/name casts