pgsql: Doc: improve description of allowed spellings for Booleaninput. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: improve description of allowed spellings for Booleaninput.
Date
Msg-id E1hbFtc-00041f-TZ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: improve description of allowed spellings for Boolean input.

datatype.sgml failed to explain that boolin() accepts any unique
prefix of the basic input strings.  Indeed it was actively misleading
because it called out a few minimal prefixes without mentioning that
there were more valid inputs.

I also felt that it wasn't doing anybody any favors by conflating
SQL key words, valid Boolean input, and string literals containing
valid Boolean input.  Rewrite in hopes of reducing the confusion.

Per bug #15836 from Yuming Wang, as diagnosed by David Johnston.
Back-patch to supported branches.

Discussion: https://postgr.es/m/15836-656fab055735f511@postgresql.org

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/909a92e1955256f41c411961e400a145d581ed2d

Modified Files
--------------
doc/src/sgml/datatype.sgml | 66 ++++++++++++++++++++++++++++++----------------
1 file changed, 43 insertions(+), 23 deletions(-)


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: docs: PG 12 relnotes, update btree items
Next
From: Tom Lane
Date:
Subject: pgsql: Doc: fix bogus example.