Postgres Pro
Downloads
Home   >   mailing lists

How to allow null as an option when using regexp_matches? - Mailing list pgsql-general

From Shaozhong SHI
Subject How to allow null as an option when using regexp_matches?
Date
Msg-id CA+i5JwYMPY1PwACzD4tLn0PdXuyRXBF9x+d38QfzJ1kMkRet5A@mail.gmail.com
Whole thread Raw
Responses Re: How to allow null as an option when using regexp_matches?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: How to allow null as an option when using regexp_matches?  (Roxanne Reid-Bennett <rox@tara-lu.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Working with fixed-point calculations in C
Next
From: Karsten Hilbert
Date:
Subject: Re: How to allow null as an option when using regexp_matches?