On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T <rameshparnandit...@gmail.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.
