Re: WIP: default values for function parameters

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

In response to

Browse pgsql-hackers by date

  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