agora inbox for pgsql-docs@postgresql.org  

help / color / mirror / Atom feed

From: Erik Wienhold <ewie@ewie.name>
To: evasquezg97@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: Error in Example
Date: Fri, 1 Sep 2023 17:16:52 +0200 (CEST)
Message-ID: <2000743697.23098.1693581412642@office.mailbox.org> (raw)
In-Reply-To: <169343819690.621.1560145208256468582@wrigleys.postgresql.org>
References: <169343819690.621.1560145208256468582@wrigleys.postgresql.org>

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

view thread (6+ messages)  latest in thread

Message-ID: <2000743697.23098.1693581412642@office.mailbox.org>
Permalink:  ../2000743697.23098.1693581412642@office.mailbox.org/
Also on:    postgresql.org/message-id/2000743697.23098.1693581412642@office.mailbox.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: ewie@ewie.name, evasquezg97@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: Error in Example
  In-Reply-To: <2000743697.23098.1693581412642@office.mailbox.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox