Passing composite types to plpgsql functions - Mailing list pgsql-general

From Jeff Waugh
Subject Passing composite types to plpgsql functions
Date
Msg-id 11b601c0d9b8$cfcb9750$0201a8c0@wilbur
Whole thread Raw
Responses Re: Passing composite types to plpgsql functions
List pgsql-general
/doc/html/plpgsql-description.html states that:

"Parameters to a function can be composite types (complete table rows). In
that case, the corresponding identifier $n will be a rowtype, but it must be
aliased using the ALIAS command described above."

What syntax do I need in my function declaration to receive a parameter of
something%ROWTYPE ?

Thanks,
-Jeff



pgsql-general by date:

Previous
From: ryan@paymentalliance.net
Date:
Subject: Re: Query not using index
Next
From: Bruce Momjian
Date:
Subject: Upcoming PostgreSQL seminars