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

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: BUG #5867: wish: plpgsql print table for debug
Дата
Msg-id AANLkTi=pE5t=L+qHRrgxxpQNO2OEXmm1HJeZw_Sqy=Ui@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #5867: wish: plpgsql print table for debug  (Richard Neill <rjn@richardneill.org>)
Список pgsql-bugs
On Thu, Mar 3, 2011 at 12:37 PM, Richard Neill <rjn@richardneill.org> wrote:
>
>> Sure it does. =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. =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....

raise notice '%', (select array_to_string(array(select foo from foo), E'\n'=
));

:^).

merlin

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #5867: wish: plpgsql print table for debug
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: BUG #5867: wish: plpgsql print table for debug