[int_19h]

Except they don't consistently behave that way. If NULL means "unknown", why do they show up in outer joins, or when you SUM an empty table?

[cglace]

The most annoying is having to order by DESC NULLS LAST to get the largest value from an aggregation.