Re: How to clone CURRENT_DATE to SYSDATE ?

Hi

2014-09-25 12:24 GMT+02:00 Emanuel Araújo <eacshm(at)gmail(dot)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

>
> 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(dot)klaver(at)aklaver(dot)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:
>>
>> http://www.postgresql.org/message-id/1409288790481-
>> 5816851(dot)post(at)n5(dot)nabble(dot)com
>>
>>
>>>
>>> --
>>> *Atenciosamente,
>>>
>>> Emanuel Araújo*
>>> */Linux Certified, DBA PostgreSQL
>>> /*
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>
>
>
> --
>
>
> *Atenciosamente,Emanuel Araújo*
>
> *Linux Certified, DBA PostgreSQL*
>