Re: postgresql vs mysql - Mailing list pgsql-general

From Glen Parker
Subject Re: postgresql vs mysql
Date
Msg-id 45DF48CF.9020301@nwlink.com
Whole thread Raw
In response to Re: postgresql vs mysql  (Ben <bench@silentmedia.com>)
Responses Re: postgresql vs mysql  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Ben wrote:
> I'm sorry maybe I missed something, but if you don't need NULLs and feel
> they just add extra work, why don't you just declare all your columns to
> be not null and have them default to zero or an empty string?

Because I DO need NULLS for non text fields, and I still want NULL to
compare equal to, say, '' and 0.  I don't think you read what I wrote...

Put another way, I would like to redefine NULL to mean BLANK or NOT
ENTERED.  Totally different concept.

-Glen


pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: postgresql vs mysql
Next
From: Ron Mayer
Date:
Subject: Re: Priorities for users or queries?