Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation - Mailing list pgsql-bugs

From Daniele Varrazzo
Subject Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation
Date
Msg-id AANLkTingKKwwBTLIJas2PRd8coEhAW0b9mbBvMJaNNNz@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
On Sun, May 30, 2010 at 4:45 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Sat, May 29, 2010 at 5:00 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> I have updated the patch, attached, to clarify that this returns text
>> arrays, and that you can force it to always return one row using
>> COALESCE() and a '|' pattern (the later suggested by Daniele Varrazzo).
>
> I don't find this part to be something we should include in the
> documentation. =A0If we want to include a workaround, how about defining
> a non-SRF that just calls the SRF and returns the first row?

I think a documentation correction could be backported without problem
to all the currently maintained version of PostgreSQL (which would be
of good google value, as very often google searches lands you to
previous releases doc pages), whereas a easier to use function would
be a new feature and as such could only be introduced in 9.0 or even
9.1.

-- Daniele

pgsql-bugs by date:

Previous
From: "Sergey"
Date:
Subject: BUG #5484: sum() bug
Next
From: Tom Lane
Date:
Subject: Re: BUG #5484: sum() bug