Re: [GENERAL] Trouble with regexp_matches

2016-11-05 Thread Tom Lane
Edson Richter writes: > I’m running the query below, and it is limiting results as if > “regexp_matches” being in where clause. > IMHO, it is wrong: in case there is no match, shall return null or empty > array – not remove the result from the set!!! Well, no, because regexp_matches() returns a

Re: [GENERAL] Trouble with regexp_matches

2016-11-05 Thread Adrian Klaver
On 11/05/2016 10:01 AM, Edson Richter wrote: Dear list, Version stringPostgreSQL 9.4.10 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit I’m running the query below, and it is limiting results as if “regexp_matches” being in where clause. IMHO