Re: Document NULL

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(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: 2024-12-29 03:30:00
Message-ID: CACJufxG75TO7CvC8vJ6h8iC1ojgBdY-VW_71p+5jBFr0nAsDGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

"SQL specification" should be "SQL standard"?

+ another null vale and unequal to all other values.
typo. should be "another null value"

other places using subsection, many places in doc/src/sgml/nullvalues.sgml
using "sub-section".

+ Notice two important behaviors: first, even though we passed in a
null value to
+ to the <literal>set_config</literal> function, the
<literal>current_setting</literal>
there is two "to to".

gmail has grammar checks, chatgpt can also help find typos.
you can give it a try.

+ <programlisting>
+ BEGIN;
+ ALTER TABLE null_examples ADD CONSTRAINT value_not_1 CHECK (value != 1);
+ ROLLBACK;
+ </programlisting>
+ <screen>
+ BEGIN
+ ERROR: check constraint "value_not_1" of relation
"null_examples" is violated by some row
+ ROLLBACK
+ </screen>
+ <programlisting>
+ BEGIN;
+ ALTER TABLE null_examples ADD CONSTRAINT value_not_10 CHECK (value != 10);
+ ROLLBACK;
+ </programlisting>
+ <screen>
+ BEGIN
+ ALTER TABLE
+ ROLLBACK
+ </screen>

i think this part, BEGIN... ROLLBACK is not necessary.
since if we add these check constraints, it won't influence the
later(next) section.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2024-12-29 06:24:55 Re: Re: proposal: schema variables
Previous Message jian he 2024-12-29 02:48:51 Re: Re: proposal: schema variables