Re: Clarification on interactions between query parameters and partial indexes

2020-03-17 Thread Bruce Momjian
On Fri, Feb 14, 2020 at 11:42:34AM -0500, Tom Lane wrote: > PG Doc comments form writes: > > In section "11.8 Partial Indexes" it states the following: > > > "Matching takes place at query planning time, not at run time. As a result, > > parameterized query clauses do not work with a partial

Re: Clarification on interactions between query parameters and partial indexes

2020-02-14 Thread Tom Lane
PG Doc comments form writes: > In section "11.8 Partial Indexes" it states the following: > "Matching takes place at query planning time, not at run time. As a result, > parameterized query clauses do not work with a partial index. For example a > prepared query with a parameter might specify “x

Clarification on interactions between query parameters and partial indexes

2020-02-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/indexes-partial.html Description: In section "11.8 Partial Indexes" it states the following: "Matching takes place at query planning time, not at run time. As a result, parameterized