Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id D68EC475450; Tue, 19 Mar 2002 15:43:09 -0500 (EST) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id PAA05082; Tue, 19 Mar 2002 15:42:03 -0500 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma005078; Tue, 19 Mar 02 15:41:46 -0500 Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id PAA07044; Tue, 19 Mar 2002 15:45:43 -0500 Message-ID: <3C97A36A.BFB6B960@nsd.ca> Date: Tue, 19 Mar 2002 15:45:30 -0500 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-12 i686) X-Accept-Language: en MIME-Version: 1.0 To: wsheldah@lexmark.com Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] How to create crude report with psql and/or plpgsql References: <200203192024.PAA04499@interlock2.lexmark.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/963 X-Sequence-Number: 22332 Wes, I Agree, but I am thinking of psql here. PSQL is a front-end to PostgreSQL. Is it not? We could still use the RAISE NOTICE or RAISE INFO on the back-end, but PSQL should strip the INFO and/or NOTICE prefix. Mind you, from the back-end perspective, a RAISE INFO or NOTICE is just like a printf. JLL wsheldah@lexmark.com wrote: > > PRINT just seems like the wrong sort of thing for a database to do. If you want > printed output, use some client language like perl, java, c, whatever, to get > stuff out of the database and print it. > > Or use one of those languages to write an easy filter that removes the INFO and > NOTICE prefixes before actually printing them. Use the right tool for the job. > > Wes Sheldahl > > Jean-Luc Lachance on 03/19/2002 02:42:52 > PM > > To: Bruce Momjian > cc: pgsql-sql%postgresql.org@interlock.lexmark.com, > pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley > Sheldahl/Lex/Lexmark) > Subject: Re: [GENERAL] [SQL] How to create crude report with psql and/or > plpgsql > > Well, count my vote. > Any body else who see the usefullness of a PRINT statement? > > Bruce Momjian wrote: > > > > Jean-Luc Lachance wrote: > > > Hello Bruce, > > > > > > How about simply PRINT; maybe something like a printf. > > > > > > Just as long as there will be no prefix like 'INFO:' or 'NOTICE:' > > > > Indeed, there will be a prefix if INFO: or NOTICE:. No one has asked > > for those to be removed before. > > > > -- > > Bruce Momjian | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 853-3000 > > + If your life is a hard drive, | 830 Blythe Avenue > > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html