Re: return setof record from function with dynamic query - Mailing list pgsql-general

On Wed, 18 Dec 2002 17:18:56 +1100
Toby Tremayne <tobyt@toll.com.au> wrote:

>    ERROR:  A column definition list is required for functions returning RECORD
>
>    I'd really appreciate it if someone could show me how to pass back
>    a set of records please???
>
> Toby
>
> CREATE FUNCTION poptions (INTEGER)
> RETURNS setof record AS '
> DECLARE
>         -- parameters
>         p_author_id ALIAS FOR $1;
>
>         -- local variables
>         row_data poem_option_def%ROWTYPE;
>         newrows record;


Possibly, Grant's advice will help you. Maybe around the description
of CREATE TYPE.

http://archives.postgresql.org/pgsql-hackers/2002-09/msg01741.php



Regards,
Masaru Sugawara