Re: Using rowtype as function argument - Mailing list pgsql-sql

From Tom Lane
Subject Re: Using rowtype as function argument
Date
Msg-id 18361.1060180837@sss.pgh.pa.us
Whole thread Raw
In response to Using rowtype as function argument  (Martin Brommer <martin@brommer.nl>)
List pgsql-sql
Martin Brommer <martin@brommer.nl> 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(mytablename) FROM mytablename;
        regards, tom lane


pgsql-sql by date:

Previous
From: Jodi Kanter
Date:
Subject: Re: looking for empty fields
Next
From: Stef
Date:
Subject: Analyze makes queries slow...