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-00041h-TN@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
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/457dab1e7bc694811974a24690846de00de6b4fb

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.