Am Wed, Dec 08, 2021 at 12:07:13PM +0000 schrieb Shaozhong SHI:
> We can do this: > select count(*) from regexp_matches('Great London', 'Great > London|Information Centre|Department for Transport', 'g'); > > Is it possible to allow null as an option? something like this > select count(*) from regexp_matches('Great London', 'null|Great > London|Information Centre|Department for Transport', 'g');