Re: [SQL] echo/printf function in plpgsql

2005-07-20 Thread Andreas Joseph Krogh
On Wednesday 20 July 2005 01:39, John DeSoi wrote: > On Jul 19, 2005, at 11:58 AM, Andreas Joseph Krogh wrote: > > I see. Can I make the ouput somehow less verbose? It spits out a > > lot of noise > > for each "NOTICE": > > If you just want to output some information to the log, you can use > somet

Re: [SQL] echo/printf function in plpgsql

2005-07-19 Thread John DeSoi
On Jul 19, 2005, at 11:58 AM, Andreas Joseph Krogh wrote: I see. Can I make the ouput somehow less verbose? It spits out a lot of noise for each "NOTICE": If you just want to output some information to the log, you can use something like this: raise log 't is %', t; If I recall correct

Re: [SQL] echo/printf function in plpgsql

2005-07-19 Thread Andreas Joseph Krogh
On Tuesday 19 July 2005 22:09, Tony Wasson wrote: > On 7/19/05, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > > On Tuesday 19 July 2005 17:18, Richard Huxton wrote: > > > Andreas Joseph Krogh wrote: > > > > Hi all! > > > > > > > > Is there a way of echo'ing a string(like "raise notice 'this is

Re: [SQL] echo/printf function in plpgsql

2005-07-19 Thread Tony Wasson
On 7/19/05, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > On Tuesday 19 July 2005 17:18, Richard Huxton wrote: > > Andreas Joseph Krogh wrote: > > > Hi all! > > > > > > Is there a way of echo'ing a string(like "raise notice 'this is id%', > > > id") from plpgsql? I want to echo/print it to STDO

Re: [SQL] echo/printf function in plpgsql

2005-07-19 Thread Andreas Joseph Krogh
On Tuesday 19 July 2005 17:18, Richard Huxton wrote: > Andreas Joseph Krogh wrote: > > Hi all! > > > > Is there a way of echo'ing a string(like "raise notice 'this is id%', > > id") from plpgsql? I want to echo/print it to STDOUT 'cause the > > notice-mechanism produces too much noise IMH. > > Your

Re: [SQL] echo/printf function in plpgsql

2005-07-19 Thread Richard Huxton
Andreas Joseph Krogh wrote: Hi all! Is there a way of echo'ing a string(like "raise notice 'this is id%', id") from plpgsql? I want to echo/print it to STDOUT 'cause the notice-mechanism produces too much noise IMH. Your function is running in the backend. You don't have a STDOUT (although

[SQL] echo/printf function in plpgsql

2005-07-19 Thread Andreas Joseph Krogh
Hi all! Is there a way of echo'ing a string(like "raise notice 'this is id%', id") from plpgsql? I want to echo/print it to STDOUT 'cause the notice-mechanism produces too much noise IMH. -- Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9'