Thread: 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