From: Richard Huxton <dev@archonet.com>
To: Christopher Sawtell <csawtell@xtra.co.nz>
To: Richard Huxton <dev@archonet.com>
To: pgsql-sql@postgresql.org
Subject: Re: my pgsql error?
Date: Wed, 14 Mar 2001 09:54:33 -0000
Message-ID: <20010314095433.E00372A683@mainbox.archonet.com> (raw)
In-Reply-To: <01031409065400.03143@berty>
Christopher Sawtell <csawtell@xtra.co.nz> said:
> On Wed, 14 Mar 2001 01:38, Richard Huxton wrote:
> > From: "Christopher Sawtell" <csawtell@xtra.co.nz>
> >
> > > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, csawtell@xtra.co.nz
Subject: Re: my pgsql error?
In-Reply-To: <20010314095433.E00372A683@mainbox.archonet.com>
References: <01031409065400.03143@berty> <20010314095433.E00372A683@mainbox.archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox