Re: ROWTYPE as parameter to function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ROWTYPE as parameter to function
Date: 2002-04-19 21:28:03
Message-ID: 4536.1019251683@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David A Dickson 2002-04-19 21:33:13 Re: creating table w/ php help
Previous Message William Meloney 2002-04-19 21:22:11 Re: unable to repair table: missing chunk number