Re: regexp on null

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: regexp on null
Date: 2010-09-10 16:14:19
Message-ID: AANLkTi=Gq=WR1oGLz1LDw+rkLntfca9oaaYNhBORRZG-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey Dave,

Did you consider to use coalesce() ?

Regards,
Dmitriy

2010/9/10 Gauthier, Dave <dave(dot)gauthier(at)intel(dot)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 !
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2010-09-10 16:19:01 Re: regexp on null
Previous Message David Fetter 2010-09-10 16:04:57 Re: Post Install / Secure PostgreSQL