public inbox for [email protected]  

help / color / mirror / Atom feed

PostgreSQL Module to use Oracle specific functions as it is.
3+ messages / 3 participants
[nested] [flat]

* PostgreSQL Module to use Oracle specific functions as it is.
@ 2020-07-01 14:38  Chamath Sajeewa <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Chamath Sajeewa @ 2020-07-01 14:38 UTC (permalink / raw)
  To: [email protected]

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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PostgreSQL Module to use Oracle specific functions as it is.
@ 2020-07-01 14:41  Laurenz Albe <[email protected]>
  parent: Chamath Sajeewa <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Laurenz Albe @ 2020-07-01 14:41 UTC (permalink / raw)
  To: Chamath Sajeewa <[email protected]>; [email protected]

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PostgreSQL Module to use Oracle specific functions as it is.
@ 2020-07-01 14:41  Stephen Frost <[email protected]>
  parent: Laurenz Albe <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Stephen Frost @ 2020-07-01 14:41 UTC (permalink / raw)
  To: Laurenz Albe <[email protected]>; +Cc: Chamath Sajeewa <[email protected]>; [email protected]

Greetings,

* Laurenz Albe ([email protected]) 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


Attachments:

  [application/pgp-signature] signature.asc (819B, ../../[email protected]/2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2020-07-01 14:41 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-01 14:38 PostgreSQL Module to use Oracle specific functions as it is. Chamath Sajeewa <[email protected]>
2020-07-01 14:41 ` Laurenz Albe <[email protected]>
2020-07-01 14:41   ` Stephen Frost <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox