Re: Name the Parameters - Mailing list pgsql-sql

From Ian Barwick
Subject Re: Name the Parameters
Date
Msg-id 200309060721.26358.barwick@gmx.net
Whole thread Raw
In response to Name the Parameters  ("Kumar" <sgnerd@yahoo.com.sg>)
List pgsql-sql
On Saturday 06 September 2003 06:42, Kumar wrote:
> Dear Gurus,
>
> Is it possible to name the IN parameters of the PLpgSQL Functions. Because
> naming the parameter will ease coding. See the following function for
> insert, having 10 parameters as a input.

No, though there is an item on the TODO list IIRC. 

Using ALIAS FOR might make things easier though, something
along the lines of:
 DECLARE  address_id ALIAS FOR $1;  address ALIAS FOR $2;  ... BEGIN  ...
 END;

Ian Barwick
barwick@gmx.net



pgsql-sql by date:

Previous
From: sad
Date:
Subject: Re: recursive sql
Next
From: Alexei Chetroi
Date:
Subject: SQL subqueries newbie help