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.
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 |