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

From Tom Lane
Subject Re: Named arguments in function calls
Date
Msg-id 8000.1075134241@sss.pgh.pa.us
Whole thread Raw
In response to Re: Named arguments in function calls  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Named arguments in function calls  (Matthew Kirkwood <matthew@hairy.beasts.org>)
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.

On second thought though, it doesn't work.
select func(x is null);

is ambiguous, especially if func() accepts boolean.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: cache control?
Next
From: Tom Lane
Date:
Subject: Re: Named arguments in function calls