Oracle function to PostgreSQL

Question

I'm try to convert my Oracle function which contains SUBSTR() to PostgreSQL. Is there an equivalent function in PSQL? Thanks.

I manage to find a Oracle Instr() conversion to PostgreSQL.

Pavel Stehule · Accepted Answer · 2014-02-01 02:51:35Z

4

You can use a code from Postgres documentation mentioned by michel-sim. Other possibility is Orafce extension - https://github.com/orafce/orafce or http://postgres.cz/wiki/Oracle_functionality_%28en%29 that is available for RedHat or Debian as binary package too.

answered Feb 1, 2014 at 2:51

Pavel Stehule

46.7k6 gold badges104 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Charlesliam Over a year ago

Thanks, I'm checking the tutorial how to install orafce. I bit tricky for not Perl user myself.

Charlesliam Over a year ago

As mention in Orafce Install.orafunc - ..install Orafce functions in the database, either run the orafce.sql script using the pgAdmin SQL tool..I tried running the orafce--3.0.sql, it give me error ERROR: could not access file "MODULE_PATHNAME": No such file or directory. What do you mean by module path?

Charlesliam Over a year ago

Here's my question on this link

Pavel Stehule Over a year ago

@Charlesliam - please, try CREATE EXTENSION orafce;

Charlesliam Over a year ago

I did try but I have a problem runnnig the CREATE EXTENSION orafce. Here's my link

michel-lind · Accepted Answer · 2014-02-01 02:13:48Z

2

There's substring, but you'd have to modify the invocations -- instead of substr(x, i, j) you need substring(x from i to j)

answered Feb 1, 2014 at 2:13

michel-lind

9,8463 gold badges35 silver badges32 bronze badges

2 Comments

Craig Ringer Over a year ago

It's trivial to write a wrapper SQL function around that, of course, giving you the substr you're used to ... but it's better to use orafce as Pavel suggested.

michel-lind Over a year ago

Indeed, I might try orafce myself for migrating some databases at work

Collectives™ on Stack Overflow

Oracle function to PostgreSQL

2 Answers 2

5 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related