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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
