ient_ip = inet '212.78.10.32';
</pre><p>
    Here the query's IP address is covered by the partial index.  The
    following query cannot use the partial index, as it uses an IP address
    that is excluded from the index:
</p><pre class="programlisting">
SELECT *
FROM access_log
WHERE url = '/index.html' AND client_ip = inet '192.168.100.23';
</pre><p>
   </p><p>
    Observe that this kind of partial index requires that the common
    values be predetermined, so such partial indexes are best used for
    d