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