Re: Named arguments in function calls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: 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 16:24:01
Message-ID: 8000.1075134241@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2004-01-26 16:42:49 Functions returning complex types.
Previous Message Tom Lane 2004-01-26 16:22:28 Re: Named arguments in function calls