Re: instr detail

[Ramesh T <rameshparnanditech@xxxxxxxxx>]

here is the example tks help..

http://stackoverflow.com/questions/2965655/how-to-find-the-first-and-last-occurrences-of-a-specific-character-inside-a-stri

On Thu, Jul 30, 2015 at 7:38 PM, Ramesh T <rameshparnanditech@xxxxxxxxx> wrote:

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@xxxxxxxxxxxxx> wrote:

Melvin Davidson <melvin6925@xxxxxxxxx> 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