Re: [GENERAL] Allowing SYSDATE to Work
От | Matt Miller |
---|---|
Тема | Re: [GENERAL] Allowing SYSDATE to Work |
Дата | |
Msg-id | 1163871723.24644.276390321@webmail.messagingengine.com обсуждение исходный текст |
Ответ на | Re: [GENERAL] Allowing SYSDATE to Work (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: [GENERAL] Allowing SYSDATE to Work
Re: [GENERAL] Allowing SYSDATE to Work |
Список | pgsql-hackers |
> > 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.
В списке pgsql-hackers по дате отправления: