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

From Tom Lane
Subject Re: %ROWTYPE as PL/pgsql argument
Date
Msg-id 24791.1017760922@sss.pgh.pa.us
Whole thread Raw
In response to Re: %ROWTYPE as PL/pgsql argument  (Jan Wieck <janwieck@yahoo.com>)
Responses Re: %ROWTYPE as PL/pgsql argument
List pgsql-general
Jan Wieck <janwieck@yahoo.com> writes:
>     At  the  time  beeing  you  can't  do that with PL/pgSQL. The
>     language can receive rows as parameters, but it cannot  build
>     those rows and pass them down to called functions.

Hmm, doesn't it work to do

    declare var some-row-type;

    select x, y, z into var;

    select otherfunc(var);

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Core dump on PG 7.1.3
Next
From: Tom Lane
Date:
Subject: Re: v7.2.1 Released: Critical Bug Fix