How to allow null as an option when using regexp_matches?

Поиск

Список

Период

Сортировка

От	Shaozhong SHI
Тема	How to allow null as an option when using regexp_matches?
Дата	8 декабря 2021 г. 12:07:13
Msg-id	CA+i5JwYMPY1PwACzD4tLn0PdXuyRXBF9x+d38QfzJ1kMkRet5A@mail.gmail.com обсуждение исходный текст
Ответы	Re: How to allow null as an option when using regexp_matches? Re: How to allow null as an option when using regexp_matches?
Список	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

В списке pgsql-general по дате отправления: