Re: my pgsql error?

Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz> said:

> On Wed, 14 Mar 2001 01:38, Richard Huxton wrote:
> > From: "Christopher Sawtell" <csawtell(at)xtra(dot)co(dot)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