> Since you've conveniently made a post that reached my mailbox right after
> a query from someone working on our toolkit port from Oracle to PG, did you
> know that in Oracle to_char formatting chars don't have to be upper case?
>
> In other words something like "to_char(sysdate, 'yyyy-mm-dd')" formats
> sysdate rather than ignore the formatting characters. Turns out the
> toolkit we're porting from Oracle almost always uses upper case, but
> not always and one of our gang just ran into this earlier this morning
> while porting over one of the toolkit module...
Doesn't the upper/lower affect how the result displays. I think that is
a cool effect.
>
> BTW, I can't begin to tell you how much easier our porting job is due
> to the existence of to_char...
Great. That is new to 7.0. We like ports _from_ Oracle.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
