Re: pg_dumplo, thanks :) (fwd)

> 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