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

From Jan Wieck
Subject Re: %ROWTYPE as PL/pgsql argument
Date
Msg-id 200204021934.g32JYC531262@saturn.janwieck.net
Whole thread Raw
In response to Re: %ROWTYPE as PL/pgsql argument  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: %ROWTYPE as PL/pgsql argument  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: [HACKERS] Unicode ready?
Next
From: Tom Lane
Date:
Subject: Re: %ROWTYPE as PL/pgsql argument