Thread: instr detail

 

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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 <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

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@sss.pgh.pa.us> wrote:

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