Search Postgresql Archives

Re: How to clone CURRENT_DATE to SYSDATE ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux