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(at)gmx(dot)net