From csawtell@xtra.co.nz Tue Jan 30 22:56:26 2001 Received: from mta3-rme.xtra.co.nz (mta3-rme.xtra.co.nz [203.96.92.13]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0UMuPq60323 for ; Tue, 30 Jan 2001 17:56:26 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty ([210.54.106.156]) by mta3-rme.xtra.co.nz with SMTP id <20010130225622.FVJZ12118861.mta3-rme.xtra.co.nz@berty> for ; Wed, 31 Jan 2001 11:56:22 +1300 Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell Organization: At Home To: "pgsql-sql@postgresql.org" Subject: Is this feature a bug? Date: Wed, 31 Jan 2001 12:03:00 +1300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01013112030000.02983@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/459 X-Sequence-Number: 1135 Greets folks. Put psql in html mode with \H execute a query. e.g.:- school=# \H Output format is html. school=# select timestamp('now');
timestamp
2001-01-31 11:24:21+13
(1 row)
Is the "( 1 row)" string really supposed to be there? imho it should not be. How can I turn it off? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<-- From olly@lfix.co.uk Wed Jan 31 02:52:33 2001 Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0V2qXq78475 for ; Tue, 30 Jan 2001 21:52:33 -0500 (EST) (envelope-from olly@lfix.co.uk) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 14NnNl-0005zD-0V; Wed, 31 Jan 2001 02:52:29 +0000 Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.11.2/8.11.2/Debian 8.11.2-1) with ESMTP id f0V2qPF10472; Wed, 31 Jan 2001 02:52:28 GMT Message-Id: <200101310252.f0V2qPF10472@linda.lfix.co.uk> X-Mailer: exmh version 2.2 06/23/2000 (debian 2.2-1) with nmh-1.0.4+dev X-URL: http://www.lfix.co.uk/oliver X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- KMLl*!h}B)u@TW|B}6 cc: "pgsql-sql@postgresql.org" Subject: Re: Is this feature a bug? In-reply-to: Message from Christopher Sawtell of Wed, 31 Jan 2001 12:03:00 +1300. <01013112030000.02983@berty> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Wed, 31 Jan 2001 02:52:25 +0000 From: "Oliver Elphick" X-Archive-Number: 200101/466 X-Sequence-Number: 1142 Christopher Sawtell wrote: >Is the "( 1 row)" string really supposed to be there? >imho it should not be. >How can I turn it off? \pset tuples_only or \t or start psql with the -t option. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "The Lord knoweth how to deliver the godly out of temptations, and to reserve the unjust unto the day of judgment to be punished;" II Peter 2:9