Postgres Pro
Downloads
Home   >   mailing lists

Re: instr detail - Mailing list pgsql-general

From Melvin Davidson
Subject Re: instr detail
Date
Msg-id CANu8Fix20JpZcFaZcpES=ZUmQOG2X8Vr2D4erUqVK_3QQRa8Tg@mail.gmail.com
Whole thread Raw
In response to Re: instr detail  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: instr detail  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Based om the definition of Oracle instr(), the equivalent PostgreSQL function would be
position(substring in string).

On Wed, Jul 29, 2015 at 3:11 PM, Igor Neyman <ineyman@perceptron.com> wrote:

 

 

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
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Synchronous replication and read consistency
Next
From: Murali M
Date:
Subject: Question about copy from with timestamp format