Documenting NULL

Documenting NULL Tracking Document

• If you wish to mark a section as ready-to-commit please add your name next to it.
• If you think it isn't ready please add a note under the section as to why.
• General comments holding back commit can be added in the ToDo Note section

Commenters

• v1 to v3
  • David Rowley
  • Laurenz Albe
  • Thom Brown
  • Tom Lane
  • Yugo NAGATA
• v4 (first full proposal)
  • jian he
  • Marcos Pegoraro

ToDo Note

• Check on implementation of comment regarding not null constraints (Laurenz)
• Examples feedback and editing pass (\pset null, quantity of) (jian)

Related Changes

• Syntax for The Null Value Constant
• Rewording tri-valued boolean logic

Main Section2s

• Meaning
• Usage
• Distinctness
• Null-Valued Operands
• Null Values in Domains
• Testing Multi-Element Values with Null Elements
• Multi-Element Predicates and Scalars
• Multi-Element Comparisons
• Null-Valued Arguments in Normal Function Calls
• Null-Valued Arguments in Aggregate and Window Functions
• Null Values in Where
• Null Values in Table Constraints
• Null Values When Grouping
• Null Values When Ordering
• Null Values in Indexes
• Null Values in Partition Keys
  • Double-negative (jian)
• Null-Valued Settings
• Null Values in JSON
  • JSON Path considerations, is distinct from exclusion (Marcos)