Nulls

• Misunderstood. An analogy: timestamps - undefined vs. unknown. NULL=NULL
   
• WHERE mytime = NULL. WHERE NULL = NULL. WHERE mytime IS NULL. WHERE hastime IS FALSE
   
• postgresql.conf: transform_null_equals
   
• Hard to pick up - use a partial index when needed
   
• Look in the pg_stats view for null_frac

Previous: Joins         [Table of Contents]         Next: Inserting/Updating