Re: WIP: Allow SQL-language functions to reference parameters by parameter name - Mailing list pgsql-hackers

From Joshua Berkus
Subject Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Date
Msg-id 154479001.271789.1301102568211.JavaMail.root@mail-1.01.com
Whole thread Raw
In response to Re: WIP: Allow SQL-language functions to reference parameters by parameter name  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Re: WIP: Allow SQL-language functions to reference parameters by parameter name
List pgsql-hackers
Tom,

> Personally I'd vote for *not* having any such dangerous semantics as
> that. We should have learned better by now from plpgsql experience.
> I think the best idea is to throw error for ambiguous references,
> period. 

As a likely heavy user of this feature, I agree with Tom here.  I really don't want the column being silently preferred
inSQL functions, when PL/pgSQL functions are throwing an error.  I'd end up spending hours debugging this.
 

Also, I don't understand why this would be a dump/reload issue if $1 and $2 continue to work.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Next
From: Robert Haas
Date:
Subject: Re: Replication server timeout patch