Re: Clarity in partial index example.

2019-04-03 Thread Jonathan S. Katz
On 4/3/19 6:30 PM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> On 4/3/19 4:20 PM, PG Doc comments form wrote: >>> Maybe I am misunderstanding the concept here but url = '/index.html' doesn't >>> have any effect on this? If that's the case I would suggest either removing >>> it from the first q

Re: Clarity in partial index example.

2019-04-03 Thread Tom Lane
"Jonathan S. Katz" writes: > On 4/3/19 4:20 PM, PG Doc comments form wrote: >> Maybe I am misunderstanding the concept here but url = '/index.html' doesn't >> have any effect on this? If that's the case I would suggest either removing >> it from the first query or adding it to the second query. >

Re: Clarity in partial index example.

2019-04-03 Thread Jonathan S. Katz
On 4/3/19 4:20 PM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/indexes-partial.html > Description: > > The example illustrating when a partial index can and cannot be used is a > little misleading.

Clarity in partial index example.

2019-04-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/indexes-partial.html Description: The example illustrating when a partial index can and cannot be used is a little misleading. The query which can use the partial index is: SELECT * FROM a