PostgreSQL Module to use Oracle specific functions as it is.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

PostgreSQL Module to use Oracle specific functions as it is.

Chamath Sajeewa
Hi,
I am new to PostgreSQl. I want to convert some oracle sql to postgre sql. Oracle sqls contain some oracle specific functions such as trunc,round. Is there any modules in postgre SQL which enable the usage of these functions as it is?
Thank you!
Chamath Sajeewa
Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL Module to use Oracle specific functions as it is.

Laurenz Albe
On Wed, 2020-07-01 at 20:08 +0530, Chamath Sajeewa wrote:
> I am new to PostgreSQl. I want to convert some oracle sql to postgre sql.
> Oracle sqls contain some oracle specific functions such as trunc,round.
> Is there any modules in postgre SQL which enable the usage of these functions as it is?

The is the "orafce" extension that provides some of that.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL Module to use Oracle specific functions as it is.

Stephen Frost
Greetings,

* Laurenz Albe ([hidden email]) wrote:
> On Wed, 2020-07-01 at 20:08 +0530, Chamath Sajeewa wrote:
> > I am new to PostgreSQl. I want to convert some oracle sql to postgre sql.
> > Oracle sqls contain some oracle specific functions such as trunc,round.
> > Is there any modules in postgre SQL which enable the usage of these functions as it is?
>
> The is the "orafce" extension that provides some of that.

Indeed, but you'd be better off just rewriting the SQL to use the
built-in functions than depending on an extension like that, imv.

Thanks,

Stephen

signature.asc (836 bytes) Download Attachment