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

From Robert Haas
Subject Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Date
Msg-id BANLkTi=Wmv7=Gg-FB0LO-p9GcbCg2RYWAg@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Allow SQL-language functions to reference parameters by parameter name  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Fri, Apr 8, 2011 at 11:51 AM, David E. Wheeler <david@kineticode.com> wrote:
> On Apr 8, 2011, at 8:05 AM, Robert Haas wrote:
>
>>> same mechanism works well in plpgsql and nobody requested a some
>>> special shortcut.
>>
>> I did.  That mechanism sucks.  But I think we're committed to doing
>> what the standard and/or Oracle do, so oh well.
>
> I think I've worked around that in PL/pgSQL using ALIAS…

I've worked around it, too, using various techniques.  That doesn't
mean it doesn't suck.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Next
From: Tom Lane
Date:
Subject: Re: workaround for expensive KNN?