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 <iney...@perceptron.com> wrote:
>
>
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Ramesh T
> *Sent:* Wednesday, July 29, 2015 12:34 PM
> *To:* pgsql-general@postgresql.org
> *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.
