Re: %ROWTYPE as PL/pgsql argument

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <janwieck(at)yahoo(dot)com>
Cc: Richard Emberson <emberson(at)phc(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: %ROWTYPE as PL/pgsql argument
Date: 2002-04-02 15:22:02
Message-ID: 24791.1017760922@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jan Wieck <janwieck(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-02 15:36:37 Re: v7.2.1 Released: Critical Bug Fix
Previous Message Tom Lane 2002-04-02 15:19:46 Re: Core dump on PG 7.1.3