Re: %ROWTYPE as PL/pgsql argument

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

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@Yahoo.com #



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