Re: [SQL] Using rowtype as function argument

2003-08-14 Thread Tom Lane
Martin Brommer <[EMAIL PROTECTED]> writes: > How do I call a function that takes a rowtype for an argument as in: > CREATE FUNCTION myfunc(mytablename) RETURNS INT AS ' SELECT myfunc(mytablename.*) FROM mytablename; This also works at the moment, but seems less clear to me: SELECT myfunc(mytable

[SQL] Using rowtype as function argument

2003-08-08 Thread Martin Brommer
Hi all, I suppose this must be easy to figure out, but I can't find it anywhere in the documentation. How do I call a function that takes a rowtype for an argument as in: CREATE FUNCTION myfunc(mytablename) RETURNS INT AS ' BEGIN -- Do stuff RETURN val; END; ' LANGUAGE 'plpgsql'