Error in Example
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/indexes-partial.html
Description:
The IP addresses used to exemplify which one will be covered by the partial
index are inverted.
On 31/08/2023 01:29 CEST PG Doc comments form <noreply@postgresql.org> wrote:
Page: https://www.postgresql.org/docs/15/indexes-partial.html
Description:The IP addresses used to exemplify which one will be covered by the partial
index are inverted.
No, the example is correct. It's about only indexing addresses outside some
hypothetical organization's subnet 192.168.100.0/24. Notice that the index
predicate is negated.
Of course the predicate could be written without inverting the range:
WHERE (client_ip <= inet '192.168.100.0' OR
client_ip >= inet '192.168.100.255')
--
Erik