Re: %ROWTYPE as PL/pgsql argument - Mailing list pgsql-general

Richard Emberson <emberson@phc.net> writes:
> CREATE OR REPLACE FUNCTION testFunc(mytable%ROWTYPE)

There's no %ROWTYPE in Postgres SQL.  There's no need for it, because
the table name is also the name of the rowtype datatype --- so you
should have written just

CREATE OR REPLACE FUNCTION testFunc(mytable)

            regards, tom lane