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 <ineyman@xxxxxxxxxxxxxx> wrote:
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ramesh T
Sent: Wednesday, July 29, 2015 12:34 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
