Re: regexp on null - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: regexp on null
Date
Msg-id AANLkTi=Gq=WR1oGLz1LDw+rkLntfca9oaaYNhBORRZG-@mail.gmail.com
Whole thread Raw
In response to regexp on null  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Hey Dave,

Did you consider to use coalesce() ?

Regards,
Dmitriy

2010/9/10 Gauthier, Dave <dave.gauthier@intel.com>

8.3.4 on Linux

 

Is there a way to regexp match on a null value?  Or is it necessary to OR in a .... "or x is null"?

 

Thanks in Advance !


pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: regexp on null
Next
From: Richard Broersma
Date:
Subject: Re: regexp on null