Re: postgres function

'123-987-123' it is not fixed some times it may be '1233-9873-123-098'
as you said it's fixed,

changes the values in middle of the -

sometimes times i need 1233 and 098 or 9873,first position i'll find
direct for second variable we don't know where it's end with -

i.e ,
i need to find second postition of the variable between the '-'

On Thu, Oct 15, 2015 at 6:32 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
> wrote:
>
>> select position('-' in '123-987-123')
>> position
>> ---
>> 4
>> But I want second occurrence,
>> position
>> -------------
>> 8
>>
>> plz any help..?
>>
>>
> ​
> SELECT length((regexp_matches('123-987-123', '(\d{3}-\d{3}-)\d{3}'))[1])
> ​
>
> David J.
>
>