Re:PostgreSQL and UUID as Primary Key
by necovek on Sunday July 07, 2024 @03:52AM
(#40895927)
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.
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.