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@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)