How to allow null as an option when using regexp_matches?
Shaozhong SHI <shishaozhong@gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2021-12-08T12:07:13Z
Lists: pgsql-general
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');
Regards,
David