Re: [GENERAL] Allowing SYSDATE to Work - Mailing list pgsql-hackers

From Matt Miller
Subject Re: [GENERAL] Allowing SYSDATE to Work
Date
Msg-id 1163871723.24644.276390321@webmail.messagingengine.com
Whole thread Raw
In response to Re: [GENERAL] Allowing SYSDATE to Work  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: [GENERAL] Allowing SYSDATE to Work  (Josh Berkus <josh@agliodbs.com>)
Re: [GENERAL] Allowing SYSDATE to Work  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List 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 by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: Proposal: syntax of operation with tsearch'sconfiguration
Next
From: "Dave Page"
Date:
Subject: Re: Proposal: syntax of operation with tsearch's configur