Re: BUG #5867: wish: plpgsql print table for debug

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: BUG #5867: wish: plpgsql print table for debug
Дата
Msg-id AANLkTimOtW2p3kaUpSeF8vH7wOLORHv2akj1W_kiAfSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #5867: wish: plpgsql print table for debug  (Richard Neill <rjn@richardneill.org>)
Список pgsql-bugs
2011/3/3 Richard Neill <rjn@richardneill.org>:
>
>> Sure it does. =C2=A0You can pass the tuple to RAISE NOTICE easily enough.
>> It won't have all the same bells and whistles psql would supply, but
>> it prints out well enough for debugging. =C2=A0Or at least it's never
>> bothered me.
>
> Sorry if I'm being dense, but I can't see how you can pass a tuple; I thi=
nk
> raise-notice only lets you pass individual strings/integers. But I don't
> think we can pass all of them without specifying in advance how many there
> are....

yes, it's possible for ROW or RECORD datatype

Regards

Pavel Stehule

>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Richard Neill
Дата:
Сообщение: Re: BUG #5867: wish: plpgsql print table for debug
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: BUG #5867: wish: plpgsql print table for debug