Re: WIP: default values for function parameters

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: WIP: default values for function parameters
Date: 2008-12-12 14:23:28
Message-ID: 494273E0.4010003@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David E. Wheeler wrote:
> Coming to this a bit late, but it seems to me that, while it makes sense
> to assign a label to a value using "AS", it's kind of weird to use it to
> assign a value to a label.
>
> SELECT foo( bar => 'ick', baz => 'ack' );
> SELECT foo( bar AS 'ick', baz AS 'ack' );

We could do it the other way round:

SELECT foo( 'ick' AS bar, 'ack' AS baz);

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-12-12 14:35:09 Re: benchmarking the query planner
Previous Message Tom Lane 2008-12-12 14:22:30 Re: WIP: default values for function parameters