Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Fri, 10 Aug 2007, Tom Lane wrote:
>> Is this what we want? Arguably regexp_split is doing the most
>> reasonable thing for its intended usage, but the strict definition of
>> regexp matching seems to require what regexp_matches does. I think
>> we ne
On Fri, 10 Aug 2007, Tom Lane wrote:
> I noticed the following behavior in CVS HEAD, using a pattern that is
> capable of matching no characters:
>
> regression=# SELECT foo FROM regexp_matches('ab cde', $re$\s*$re$, 'g') AS
> foo;
> foo
> ---
> {""}
> {""}
> {" "}
> {""}
> {""}
> {"
>
> If you count carefully, you will see that regexp_matches() reports a
> match of the pattern at the start of the string and at the end of the
> string, and also just before 'c' (after the match to the single space).
> However, regexp_split() disregards these "degenerate" matches of the
> same pa
I noticed the following behavior in CVS HEAD, using a pattern that is
capable of matching no characters:
regression=# SELECT foo FROM regexp_matches('ab cde', $re$\s*$re$, 'g') AS foo;
foo
---
{""}
{""}
{" "}
{""}
{""}
{""}
{""}
(7 rows)
regression=# SELECT foo FROM regexp_split_to
