Re: patch adding new regexp functions

Jeremy Drake <pgsql@jdrake.com> writes:
> On Sat, 17 Feb 2007, Tom Lane wrote:
>> So I'd vote against complicating the API in order to make special
>> provision for these results.  I claim that all we need is a function
>> taking (string text, pattern text, flags text) and returning either
>> array of text or setof text

> For this function, it would be setof array of text, as the capture groups
> would definitely go in an array, but if you asked for global in the flags,
> there could be more than one match in the string.

Oh, right.  And you could do a 2-D array if you wanted it all in one
blob (or a guarantee of order).  So no need for record-returning functions?

            regards, tom lane