Re: [GENERAL] postgres function

[Ramesh T]

 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.johns...@gmail.com> wrote:

> On Wed, Oct 14, 2015 at 9:38 AM, Ramesh T <rameshparnandit...@gmail.com>
> 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.
>
> ​
>
>