From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
---|---|
To: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
Cc: | Ian Caulfield <ian(dot)caulfield(at)gmail(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: default values for function parameters |
Date: | 2008-12-12 13:41:11 |
Message-ID: | 9D75A161-0BF0-43AF-A8C5-4487DC23E1AB@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Dec 12, 2008, at 2:33 PM, Dimitri Fontaine wrote:
>
> Ok, time to revisit the classics then ;)
> http://www.gigamonkeys.com/book/functions.html#keyword-parameters
>
> That would give us things like this:
> SELECT foo(1, :name 'bar', :quantity 10);
>
> As colon character does not appear in the list of allowed characters
> for the CREATE OPERATOR, it seems it could be valid.
> http://www.postgresql.org/docs/8.3/interactive/sql-
> createoperator.html
Oh, I like the colon, but better at the end of the label:
SELECT foo(1, name: 'bar', quantity: 10);
Best,
Daivd
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2008-12-12 13:43:02 | Re: WIP: default values for function parameters |
Previous Message | Alvaro Herrera | 2008-12-12 13:40:12 | Re: PostgreSQL 8.3.4 reproducible crash |