3 ms·
Yeah, it works for "partial indexes" very well. There are limits to what gets matched, for sure. In the old times, if you created a "partial index" with a cond
by necovek 2y ago
Yeah, it works for "partial indexes" very well. There are limits to what gets matched, for sure.
In the old times, if you created a "partial index" with a condition of "field_foo IS TRUE" it would not match queries asking for "field_foo = TRUE" (it did actual text matching). Probably some of that is improved today.