On 12/03/2005 11:31:34 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> Speaking of documentation, it's none too clear that
> %ROWTYPE does not seem to work when declaring plpgsql
> functions.
There is noplace that claims that it does. Perhaps you
are looking for %TYPE?
Nope. I saw this:
----<snip>-----
36.4.3. Row Types
...
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.
----<snip>-----
and figured that if it was a row variable I could/should declare it
as such when defining the function. It just seemed a little wierd
not to have the %ROWTYPE because AFIK you need it when declaring
in plpgsql's DECLARE and otherwise the function argument declarations
look like DECLARE declarations.
No biggie. Figured I'd throw it out there (to keep me away
from my real work. ;)
Karl <[EMAIL PROTECTED]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
