PostgreSQL – Extract Value Between First Set of Parenthesis
Consider a string like Ana (16) and Brian (14) are my children. How to get the value of the first parenthesis? ('16' in this case.) I tried with substring('Ana (16) and Brian (14) are my children.' from '((.+))') But it…