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 tryi
Hi
2014-09-25 12:24 GMT+02:00 Emanuel Araújo :
> 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 ;
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
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
Hi,
I need to clone function CURRENT_DATE to SYSDATE in my PostgreSQL.
Does anybody know how to do that it ?
--
*Atenciosamente,Emanuel Araújo*
*Linux Certified, DBA PostgreSQL*