From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Don Baccus <dhogaza(at)pacifier(dot)com>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: pg_dumplo, thanks :) (fwd) |
Date: | 2000-04-06 18:40:54 |
Message-ID: | Pine.LNX.3.96.1000406201231.6858A-100000@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Thu, 6 Apr 2000, Bruce Momjian wrote:
> > 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.
Thanks Don. I tomorrow check it and comperate it with Oracle and if is here
a problem I fix it. In stable 7.0 it will right.
PG's to_char() is based on upper case. Hmm, but it is not easy, it must be
case sensitive for some format-pictures (like to_char(now(), 'Day') and for
to_char(now(), 'yyyy') is upper/lower without effect. I fix it and add this
feature to internal to_char's parser.
Karel
From | Date | Subject | |
---|---|---|---|
Next Message | Don Baccus | 2000-04-06 18:46:40 | Re: pg_dumplo, thanks :) (fwd) |
Previous Message | Don Baccus | 2000-04-06 18:34:05 | Re: Book and TEMP vs. TEMPORARY |
From | Date | Subject | |
---|---|---|---|
Next Message | Don Baccus | 2000-04-06 18:46:40 | Re: pg_dumplo, thanks :) (fwd) |
Previous Message | Bruce Momjian | 2000-04-06 18:06:50 | Re: pg_dumplo, thanks :) (fwd) |