Comparison Predicates - example - documentation seems contradictory?

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: benkoshy(at)hotmail(dot)com
Subject: Comparison Predicates - example - documentation seems contradictory?
Date: 2022-10-06 23:50:26
Message-ID: 166510022672.661.15495990607469895016@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/functions.html
Description:

https://www.postgresql.org/docs/14/functions-comparison.html

See the heading: "Table 9.2. Comparison Predicates"

"2 BETWEEN 3 AND 1 → f" # ok this is false.

But let's read the example immediately below (the 'not between' example)

2 NOT BETWEEN 1 AND 3 → f # what? This is also false. how can the negation
also be the same value? I would expect it to be true?

That doesn't seem right?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Erki Eessaar 2022-10-07 08:05:36 Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely
Previous Message Bruce Momjian 2022-10-06 14:28:27 Re: request clarification on pg_restore documentation