John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> I don't think that null values are indexed - you'll probably need to coalesce
> your null data value to some value if you want it indexed.
That is most definitely not true for Postgres. NULL values are included in the
index.
However NULLs sort as greater than all values in Postgres. So when you sort
descending they'll appear *first*. If you sort ascending they'll appear last.
If you have any clauses like 'WHERE col > foo' then it will not be true for
NULL values of col regardless of what foo is and those records will be
dropped. This is true regardless of whether there's an index.
--
greg
---------------------------(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
