query plan using partial index expects a much larger number of rows than is possible

u, compiled by gcc, a 97d579287 p 0be2109a97, 64-bit (1 row) I'm wondering if the behavior that I'm seeing is expected in 12.4, and if so if it changes in a later version or if I should file an enhancement request? Or if it's not expected is there's something I'm doing wrong, or should file a bug? Thanks for your time. -- Olivier Poquet opoq...@plumdev.com

Re: query plan using partial index expects a much larger number of rows than is possible

Thanks Tom, That makes perfect sense. I'd already gone the route of materializing the condition but I didn't even realize that generated columns was an option (I'd done the same with triggers instead). So thanks a lot of that too! -- Olivier Poquet opoq...@plumdev.com