Re: Document NULL

On Sat, Jun 29, 2024 at 4:40 AM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> The attached are complete and ready for review. I did some file structure reformatting at the end and left that as the second patch. The first contains all of the content.
>
> I'm adding this to the commitfest.
>
> Thanks!
>
> David J.

in doc/src/sgml/nullvalues.sgml
can we mention
\pset null NULL
command, then NULL means this value is NULL.

you can also see doc/src/sgml/func.sgml
(The above example can be copied-and-pasted
into <application>psql</application> to set things up for the following
examples.
-------------------------------------------------------------
in doc/src/sgml/nullvalues.sgml
see the attached for one example output

in doc/src/sgml/nullvalues.sgml we have
one_whitespace<programlisting>
two_whitespace<programlisting>
three_whitespace<programlisting>
four_whitespace<programlisting>

i think you need zero whitespace for tag <programlisting>. like
<programlisting>
</programlisting>

https://tdg.docbook.org/tdg/4.5/programlisting
says whitespaces are significant.

<<>>
As noted in <xref linkend="json-type-mapping-table"/>, JSON has a null value
that does not get exposed at the SQL level.
<<>>
i feel like this sentence is weird. since these two are different things.

I think some of the query and query output can be combined into one
<programlisting>.
no need one <programlisting> for the query, one <screen> for the output.
see example in doc/src/sgml/datatype.sgml.

<programlisting>
SELECT '2 years 15 months 100 weeks 99 hours 123456789 milliseconds'::interval;
interval
---------------------------------------
3 years 3 mons 700 days 133:17:36.789
</programlisting>