How to clone CURRENT_DATE to SYSDATE ?

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:

/messages/by-id/1409288790481-5816851.post@n5.nabble.com

--
*Atenciosamente,

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

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thank's Adrian,

I want really create another CURRENT_DATE called SYSDATE.

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@aklaver.com>:

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:

/messages/by-id/1409288790481-
5816851.post@n5.nabble.com

--
*Atenciosamente,

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

--
Adrian Klaver
adrian.klaver@aklaver.com

--

*Atenciosamente,Emanuel Araújo*

*Linux Certified, DBA PostgreSQL*

Hi

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

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

On 09/25/2014 03:24 AM, Emanuel Ara�jo wrote:

Thank's Adrian,

I want really create another CURRENT_DATE called SYSDATE.

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.

Best guess is the answer lies here:

http://www.symmetricds.org/doc/3.6/user-guide/html/config.html#configuration-transforms

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general