On 2004.04.29 17:58 Tom Lane wrote:
"Karl O. Pinc" <kop@meme.com> writes: > Thought perhaps some other eyes than mine can tell if I'm doing > something wrong here or if there's a bug somewhere. I've never > passed a ROWTYPE varaible to a function
plpgsql doesn't support that. It might do so for 7.5, if anyone gets around to finishing the work I started.
What a drag. The documentation says it supports this. Is this a bug in the documentation
or something I'm not understanding?
See: http://www.postgresql.org/docs/7.4/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-ROWTYPES
"Parameters to a function can be composite types (complete table rows). In that case, the corresponding identifier $n will be a row variable, and fields can be selected from it, for example $1.user_id."
Thanks for the help.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
