Oracle function to PostgreSQL

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.

Answers


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.


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)


Need Your Help

Easiest way to run shell script objective-c

objective-c cocoa system

I am a objective-c newbe and am wondering how to run a shell script in objective-c easiest way possible. I don't care about any of the output. I have tried system(), exec() and execl() and an NST...