Re: Proposal TODO Item: SQL-language reference parameters by name - Mailing list pgsql-hackers

From David Fetter
Subject Re: Proposal TODO Item: SQL-language reference parameters by name
Date
Msg-id 20071030163533.GA5033@fetter.org
Whole thread Raw
In response to Proposal TODO Item: SQL-language reference parameters by name  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Responses Re: Proposal TODO Item: SQL-language reference parameters by name
List pgsql-hackers
On Tue, Oct 30, 2007 at 02:31:52PM +0100, Gevik Babakhani wrote:
> Hi all,
> 
> I am working a lot with custom procedures/functions which are
> implemented in "language sql". At the moment function parameter refs
> cannot work with parameter names. I would like to try to implement
> this. The actual TODO item is:
> 
> Allow SQL-language functions to reference parameters by parameter
> name 

I'm thinking we should make named parameters available to all the PLs,
if possible, as re-implementing named parameters for each one seems
like a lot of wasted effort.

How much infrastructure and/or re-jiggering of existing PLs would be
required?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal TODO Item: SQL-language reference parameters by name
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [COMMITTERS] pgsql: simple script to pull together a very small (<500k) tar file