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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026