Re: instr detail

Melvin Davidson <melvin6925@gmail.com> writes:
> Based om the definition of Oracle instr(), the equivalent PostgreSQL
> function would be
> position(substring in string).

See http://www.postgresql.org/docs/9.4/static/plpgsql-porting.html
particularly the "appendix" at the bottom.  I'm not sure that code
is still the best way to do it (it's very old), but it's there.

            regards, tom lane