Re: Proposal TODO Item: SQL-language reference parameters by name

From: David Fetter <david(at)fetter(dot)org>
To: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal TODO Item: SQL-language reference parameters by name
Date: 2007-10-30 16:35:33
Message-ID: 20071030163533.GA5033@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2007-10-30 16:48:42 Re: Datum should be defined outside postgres.h
Previous Message Marc G. Fournier 2007-10-30 16:35:21 Re: [COMMITTERS] pgsql: simple script to pull together a very small (<500k) tar file