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