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