Re: regexp on null - Mailing list pgsql-general

From Richard Broersma
Subject Re: regexp on null
Date
Msg-id AANLkTi=mzmEzA+qpFRybKJ9j8QEOdbevU+fVX2w1Np7-@mail.gmail.com
Whole thread Raw
In response to Re: regexp on null  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: regexp on null  (David Fetter <david@fetter.org>)
List pgsql-general
On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> Ya, I kinda knew about these approaches.  The problem ahs to do with novice users who don't know about coalesce or
or;inga check ofr nulls.  I was hoping there was some special regexp expression that would match to a null. 


Perhaps the easiest was to help such users is to make the column(s) in
question NOT NULL DEFAULT ''.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: Ralph Smith
Date:
Subject: Frustration with \copy
Next
From: "A.M."
Date:
Subject: Re: sql DO in rule 9.0rc1