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

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Robert Haas" <robertmhaas@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Dimitri Fontaine" <dimitri@2ndquadrant.fr>, "Josh Berkus" <josh@agliodbs.com>, <pgsql-hackers@postgresql.org>
Date: 2011-04-14T21:20:32Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
 
>> So far the most promising proposal I've seen seems to be to let
>> id mean the parameter called id only when it can't refer to
>> anything in the query.
 
> Yeah, I've come round to that position too.  I think allowing
> parameter names to be checked only after query names is probably
> the best answer.
 
+1
 
That seems the most useful and least surprising approach to me.
 
-Kevin