Re: Document NULL

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(at)eisentraut(dot)org>, David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Subject: Re: Document NULL
Date: 2025-03-11 15:51:29
Message-ID: CAKFQuwawRTo6pVmyj2FQqKKjgiV=XPU5PTu07yNJoE_gGt_OBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Version 7
https://wiki.postgresql.org/wiki/Documenting_NULL
https://commitfest.postgresql.org/patch/5086/

The only item that came up that I'm unable to address myself is discussion
comparing a NOT NULL column constraint to an equivalent check constraint.
I've left things documented as semantically equivalent. A future patch can
clear those things up. At this point I'm considering this patch content
complete.

I figure to make any last tweaks against this version 7, combine the two
patches into one and submit v8 as ready to commit should a reviewer agree.

For now I've left v6 alone and added a diff to cover these last changes.

The markup surrounding the examples is correct now and I decided \N was the
most useful representation of NULL given that the query data is single
digit numbers. I really hate the non-readability of t/f output for
booleans so I manually cleaned those up.

David J.

Attachment Content-Type Size
v7-0002-v7-Document-NULL-delta-from-v6.patch text/x-patch 56.6 KB
v7-0001-v6-Document-NULL.patch text/x-patch 71.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2025-03-11 15:52:44 Re: Adding skip scan (including MDAM style range skip scan) to nbtree
Previous Message Mahendra Singh Thalor 2025-03-11 15:41:07 Re: Non-text mode for pg_dumpall