Received: from mta4-rme.xtra.co.nz (mta4-rme.xtra.co.nz [203.96.92.15]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2DLhfx97495 for ; Tue, 13 Mar 2001 16:43:41 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty ([210.55.120.153]) by mta4-rme.xtra.co.nz with SMTP id <20010313214348.WXVK12559245.mta4-rme.xtra.co.nz@berty>; Wed, 14 Mar 2001 10:43:48 +1300 Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell Organization: At Home To: "Richard Huxton" , Subject: Re: my pgsql error? Date: Wed, 14 Mar 2001 09:06:54 +1300 X-Mailer: KMail [version 1.2] References: <01031400530600.00996@berty> <004001c0abba$8e8dd360$1001a8c0@archonet.com> In-Reply-To: <004001c0abba$8e8dd360$1001a8c0@archonet.com> MIME-Version: 1.0 Message-Id: <01031409065400.03143@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/266 X-Sequence-Number: 1925 On Wed, 14 Mar 2001 01:38, Richard Huxton wrote: > From: "Christopher Sawtell" > > > Please could a kind soul help me with this. [ ... ] > Note to readers: this is not a general service, I'm in a good mood ;-) In that case, thank you very much indeed, and may the blessings of the Deities be on you. > For a moment I thought you could do to_char(now(),'Day DD Month YYYY' > but you're quite right you need to rtrim() the various pieces. Personally I think the fact that you have to do all that rtrim() stuff is very close to being a bug. What do you think? -- 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 <<--