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 <[email protected]> wrote: > Melvin Davidson <[email protected]> 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 >
