Re: postgres function

[Ramesh T <rameshparnanditech@xxxxxxxxx>]

 select position('-' in '123-987-123')

position

---

4

But I want second occurrence,

position

-------------

8

plz any help..?

On Thu, Oct 15, 2015 at 12:54 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wed, Oct 14, 2015 at 9:38 AM, Ramesh T <rameshparnanditech@xxxxxxxxx> wrote:

Hi All,

          Do we have  function like  regexp_substr in postgres..?

in oracle this function seach the - from 1 to 2 and return result,

regexp_substr(PART_CATG_DESC,'[^-]+', 1, 2)

​Maybe one of the functions on this page will get you what you need.

http://www.postgresql.org/docs/devel/static/functions-string.html

David J.

​