Jeff Certain <gcertain@dynamicsignal.com> writes:
> create table regex_test(filter citext);
> insert into regex_test(filter) values ('Filter Filter Filter');
> select filter, regexp_matches(filter, 'Filter', 'g') from regex_test;
> select filter, regexp_matches('Filter Filter Filter', 'Filter', 'g') from regex_test;
> Expected result:
> Both select statements should return the same number of rows. Specifically, in this case, I expect to get back 3
rows.
> Actual result:
> When referencing the filter column, only one row is ever returned. When supplying the string that is the same as the
datain the filter column, the correct number of rows are returned.
Fixed, although after discussion we concluded that we should not change
the default behavior in the back branches. See commit log message:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b1ec45994e5108d734c45876c25593823fcf8644
Thanks for the report!
regards, tom lane