On Nov 24, 2006, at 9:04 AM, Marcus Engene wrote:
There is one other case where I personally find nullable
columns a good thing: process_me ish flags. When a row
is not supposed to be processed that field is null and
when a field is null it wont be in the index [at least
on Oracle].
Actually, that's abuse of NULL. NULL is supposed to mean "I don't know".
In any case, like Oracle, PostgreSQL does not index NULL values (at
least not in btree).
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
