Received: from www-uk-05.digiserve.com ([195.97.231.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2EA4Ux84874 for ; Wed, 14 Mar 2001 05:04:38 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id KAA15226; Wed, 14 Mar 2001 10:05:22 GMT Received: from archonet.com (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with SMTP id E00372A683; Wed, 14 Mar 2001 09:54:33 +0000 (GMT) Date: Wed, 14 Mar 2001 09:54:33 -0000 To: "Christopher Sawtell" , "Richard Huxton" , Subject: Re: my pgsql error? From: "Richard Huxton" X-Mailer: TWIG 2.6.2 In-Reply-To: <01031409065400.03143@berty> Message-Id: <20010314095433.E00372A683@mainbox.archonet.com> X-Archive-Number: 200103/267 X-Sequence-Number: 1926 Christopher Sawtell said: > 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? > It certainly comes under the headings of "unexpected" and "making more work for me" but I seem to remember it's supposed to be compatible with Oracle so it might be something Oracle does. - Richard Huxton