Re: proposal sql: labeled function params - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proposal sql: labeled function params
Date
Msg-id 20284.1218808896@sss.pgh.pa.us
Whole thread Raw
In response to Re: proposal sql: labeled function params  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: proposal sql: labeled function params  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Random googling shows me that Oracle appears to use a syntax like
>     name => value
> This is actually a feature that I would like to see implemented soonish, so if 
> anyone has input on the possible syntax consequences, please comment.

We've been over this territory before.  The problem with "name => value"
is that it requires reserving a perfectly good user-defined operator name.
"value AS name", on the other hand, accomplishes the same in a more
SQL-looking fashion with no new reserved word (since AS is already
fully reserved).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: varchar/name casts
Next
From: Tom Lane
Date:
Subject: Re: So what about XSLT?