Horton
Menu

Re: ROWTYPE as parameter to function

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Nigel J. Andrews" <nandrews@investsystems.co.uk>
Cc: pgsql-general@postgresql.org
Date: 2002-04-19T21:28:03Z
Lists: pgsql-general 
"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> Obviously I can't use the RECORD type but when I create the function with:
> CREATE FUNCTION myfunction (myview%ROWTYPE) RETURNS ... ;
> the '%' gets reported in an error message.

Leave off the %ROWTYPE.  Also read the info about composite-type
arguments at
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/xfunc-sql.html

			regards, tom lane