Re: Named arguments in function calls - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Named arguments in function calls
Date
Msg-id 7977.1075134148@sss.pgh.pa.us
Whole thread Raw
In response to Re: Named arguments in function calls  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Rod Taylor wrote:
>> If that was IS, then foo(x is 13) makes sense.

> I like that syntax.  For example

> select interest(amount is 500.00, rate is 1.3)

> is very readable, yet brief.

Yes, that does read well.  And "IS" is already a keyword.  We might have
to promote it from func_name_keyword to fully reserved status, but that
doesn't seem like a big loss.  I could go with this.

(We still need to check SQL200x though ...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Named arguments in function calls
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: what does it mean