search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
1.02k stars 343 forks source link

possible simple implementation replacement of numtodsinterval #624

Closed okbob closed 6 years ago

okbob commented 6 years ago

I did new function to orafce numtodsinterval. I think, so it can be easy transformed to expression by ora2pg (when orafce is not used)

numtodsinterval(x, y) ->  (x * ('1' || y)::interval)
darold commented 6 years ago

Thanks for the report Pavel, commit 110a11c adds this translation. In next commit 6cbdd5d I have extended the translation to NUMTOYMINTERVAL() which is the same translation.