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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
