Re: postgresql vs mysql

Glen Parker schrieb:
> 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.

Not wise concept, but here you go:

WHERE coalesce(sometimesnull,'') = ''  or

WHERE coalesce(sometimesnull,0 ) = 0  ...

Regards
Tino