>>>>> "Emre" == Emre Hasegeli <emre@hasegeli.com> writes:
Emre> Attached patch adds regexp_match() function which is a simpleEmre> variant of regexp_matches() that doesn't
returna set.
We already have a function that takes a string and a regexp and returns
a single text result: substring().
Regexp flags other than 'g' can also be embedded in the regexp:
postgres=# select substring('foo bar' from '(?i)BA+');substring
-----------ba
Returning an array containing the values of all capture groups might be
more useful (substring returns the value of the first capture group if
any, otherwise the matched string).
--
Andrew (irc:RhodiumToad)