Based om the definition of Oracle instr(), the equivalent PostgreSQL function would be position(substring in string).
On Wed, Jul 29, 2015 at 3:11 PM, Igor Neyman <[email protected]> wrote: > > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Ramesh T > *Sent:* Wednesday, July 29, 2015 12:34 PM > *To:* [email protected] > *Subject:* [GENERAL] instr detail > > > > Hi All, > > is instr available in postgres 9.3..? > > > > in oracle instr('12.32.42','.',-1) ,any help appreciated > > > > __ > > > > There are lots of string functions and operators: > > > > http://www.postgresql.org/docs/9.3/static/functions-string.html > > > > There is definitely a replacement for Oracle’s instr(…). > > > > Regards, > > Igor Neyman > > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
