On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general