Hi 2014-09-25 12:24 GMT+02:00 Emanuel Araújo <eac...@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 > > 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.kla...@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: >> >> http://www.postgresql.org/message-id/1409288790481- >> 5816851.p...@n5.nabble.com >> >> >>> >>> -- >>> *Atenciosamente, >>> >>> Emanuel Araújo* >>> */Linux Certified, DBA PostgreSQL >>> /* >>> >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> > > > > -- > > > *Atenciosamente,Emanuel Araújo* > > *Linux Certified, DBA PostgreSQL* >
