Re: BUG #5867: wish: plpgsql print table for debug - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #5867: wish: plpgsql print table for debug
Date
Msg-id AANLkTimOtW2p3kaUpSeF8vH7wOLORHv2akj1W_kiAfSg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5867: wish: plpgsql print table for debug  (Richard Neill <rjn@richardneill.org>)
List 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 by date:

Previous
From: Richard Neill
Date:
Subject: Re: BUG #5867: wish: plpgsql print table for debug
Next
From: Merlin Moncure
Date:
Subject: Re: BUG #5867: wish: plpgsql print table for debug