Re: postgres function

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

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