Jeremy Drake <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq