Skip site navigation (1) Skip section navigation (2)

Re: pg_dumplo, thanks :) (fwd)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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




In response to

Responses

pgsql-hackers by date

Next:From: Don BaccusDate: 2000-04-06 18:46:40
Subject: Re: pg_dumplo, thanks :) (fwd)
Previous:From: Don BaccusDate: 2000-04-06 18:34:05
Subject: Re: Book and TEMP vs. TEMPORARY

pgsql-patches by date

Next:From: Don BaccusDate: 2000-04-06 18:46:40
Subject: Re: pg_dumplo, thanks :) (fwd)
Previous:From: Bruce MomjianDate: 2000-04-06 18:06:50
Subject: Re: pg_dumplo, thanks :) (fwd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group