Re: How to clone CURRENT_DATE to SYSDATE ?

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

2014-09-25 12:24 GMT+02:00 Emanuel Araújo <eacshm@xxxxxxxxx>:

Thank's Adrian,

I want really create another CURRENT_DATE called SYSDATE.

It needs a hack to postgres. Pseudoconstant functions needs a support in PostgreSQL parser. There is no other possibility

Pavel

 

postgres=# SELECT CURRENT_DATE ;

    date    

------------

 2014-09-25

(1 row)

I need that:

postgres=# SELECT SYSDATE ;

    date    

------------

 2014-09-25

Because, I am trying SymmetricDS between Oracle and PostgreSQL, in my case, there are a lot of fields with "DEFAULT trunc(sysdate)".  This situation break when I start the sincronization why the data type there isn't in PostgreSQL.

2014-09-24 16:43 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:

On 09/24/2014 07:39 AM, Emanuel Araújo wrote:

Hi,

I need to clone function CURRENT_DATE to SYSDATE in my PostgreSQL.

Does anybody know how to do that it ?

Not sure what you want?

A clone is an exact replica so cloning CURRENT_DATE would create another CURRENT_DATE. My guess is that this not what you want.

So do you want to create  SYSDATE in Postgres?

If so, look at this thread for the issues:

http://www.postgresql.org/message-id/1409288790481-5816851.post@xxxxxxxxxxxxx

--
*Atenciosamente,

Emanuel Araújo*
*/Linux Certified, DBA PostgreSQL
/*

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--

Atenciosamente,

Emanuel Araújo
Linux Certified, DBA PostgreSQL