[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-hackers
Subject: Re: [HACKERS] regexp_match() returning text
From: Andrew Gierth <andrew () tao11 ! riddles ! org ! uk>
Date: 2016-05-30 18:01:39
Message-ID: 871t4j5tg4.fsf () news-spur ! riddles ! org ! uk
[Download RAW message or body]
>>>>> "Emre" == Emre Hasegeli <emre@hasegeli.com> writes:
Emre> Attached patch adds regexp_match() function which is a simple
Emre> variant of regexp_matches() that doesn't return a 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)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic