Re: %ROWTYPE as PL/pgsql argument

Tom Lane wrote:
> 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);

Yes,

it doesn't work. Actually, giving just a relname as 'some-
row-type' crashes the backend. Will take a look at it
tomorrow.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com