Thread: Minor error

Minor error

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/indexes-partial.html
Description:

A sentence on this page reads:
"The system can recognize simple inequality implications, for example “x <
1” implies “x < 2”; otherwise the predicate condition must exactly match
part of the query's WHERE condition or the index will not be recognized as
usable."

I think it's supposed to read ..."x <=1" implies "x < 2"... ?

Re: Minor error

From
Daniel Gustafsson
Date:
> On 28 Feb 2020, at 15:50, PG Doc comments form <noreply@postgresql.org> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/indexes-partial.html
> Description:
>
> A sentence on this page reads:
> "The system can recognize simple inequality implications, for example “x <
> 1” implies “x < 2”; otherwise the predicate condition must exactly match
> part of the query's WHERE condition or the index will not be recognized as
> usable."
>
> I think it's supposed to read ..."x <=1" implies "x < 2"... ?

Why do you think that? x < 1 clearly implies x < 2 so I don't see what is wrong.

cheers ./daniel