Re: regexp on null

From: Richard Broersma <richard(dot)broersma(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 17:25:55
Message-ID: AANLkTi=mzmEzA+qpFRybKJ9j8QEOdbevU+fVX2w1Np7-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)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;ing a 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2010-09-10 17:30:16 Re: sql DO in rule 9.0rc1
Previous Message Ralph Smith 2010-09-10 17:25:52 Frustration with \copy