Agree with David. Regards, Dmitriy
2010/9/10 David Fetter <da...@fetter.org> > On Fri, Sep 10, 2010 at 10:25:55AM -0700, Richard Broersma wrote: > > On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave <dave.gauth...@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;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 ''. > > I think it's a very, very bad idea to make a default like that. I'm > aware that it's common in one of those Oracle properties, but it needs > to stay confined there. > > Cheers, > David. > -- > David Fetter <da...@fetter.org> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david.fet...@gmail.com > iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >