Re: instr detail

select position('.' in '.T.homas')
result
--------
1
it returns first postion.but I need last occurence of ' . ' .
actual result
------
3
any help..?appreciated.

On Thu, Jul 30, 2015 at 5:00 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Melvin Davidson <melvin6925(at)gmail(dot)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
>