From: | Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Rod Taylor <pg(at)rbt(dot)ca>, Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, elein <elein(at)varlena(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Named arguments in function calls |
Date: | 2004-01-26 18:00:58 |
Message-ID: | Pine.LNX.4.58.0401261758080.20230@sphinx.mythic-beasts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 26 Jan 2004, Tom Lane 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.
You're unlikely to care, but Oracle's syntax is Perlish:
select interest(amount => 500.0, rate => 1.3);
That'd be ambiguous again, though. Perhaps:
select interest(amount := 500.0, rate := 1.3);
?
Matthew.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-01-26 18:04:12 | Re: Disaster! |
Previous Message | Bruce Momjian | 2004-01-26 17:53:02 | Re: 7.5 change documentation |