Re: WIP: Allow SQL-language functions to reference parameters by parameter name

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>

To: Pavel Stehule <pavel.stehule@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Merlin Moncure <mmoncure@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, "David E. Wheeler" <david@kineticode.com>, Matthew Draper <matthew@trebex.net>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2011-04-08T15:05:36Z

Lists: pgsql-hackers


On 04/08/2011 10:53 AM, Pavel Stehule wrote:
>> For SQL language functions, I think you're right. The only caveat I have is
>> that if your function name is very long, having to use it as a
>> disambiguating qualifier can be a bit ugly.
> same mechanism works well in plpgsql and nobody requested a some
> special shortcut.
>

I get annoyed by it there too, that's why I mentioned it :-)

cheers

andrew