Re: %ROWTYPE as PL/pgsql argument

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: %ROWTYPE as PL/pgsql argument
Дата
Msg-id 200204021934.g32JYC531262@saturn.janwieck.net
обсуждение исходный текст
Ответ на Re: %ROWTYPE as PL/pgsql argument  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: %ROWTYPE as PL/pgsql argument  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: [HACKERS] Unicode ready?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: %ROWTYPE as PL/pgsql argument