View Single Post

   
  #10 (permalink)  
Old 04-12-2008, 06:38 AM
Matt Miller
 
Posts: n/a
Default Re: [GENERAL] Allowing SYSDATE to Work

> > Why should we add this Oraclism to PostgreSQL? I doesn't add any new
> > feature.

>
> Certainly, this feature falls well within the class of completely
> gratuitous proprietary extensions that we typically reject.


I now agree completely. My purpose is to migrate Oracle databases to
Posgres, and I had thought that Oracle didn't support CURRENT_DATE,
CURRENT_TIMESTAMP, and so on. However, I've just learned otherwise. So,
I think the proper migration process for a production database would be
to first change the Oracle DB to use CURRENT_DATE (or some other
standard psuedo column), since that will work properly under both Oracle
and Postgres.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote