Re: POC, WIP: OR-clause support for indexes

On 10/4/24 22:00, Peter Geoghegan wrote:
> I don't think that removing duplicated constants is all that
> important, since we already do that during execution proper. The
> nbtree code does this in _bt_preprocess_array_keys. It even does
> things like merge together a pair of duplicate SAOPs against the same
> column. It doesn't matter if the arrays are of different types,
> either.Hmm, my intention is a bit different - removing duplicates allows us to 
estimate selectivity more precisely, right? Maybe it is not enough to be 
a core feature, but I continue to think about auto-generated queries and 
extensions that can help generate proper plans for queries from  AI, 
ORM, etc. users.

-- 
regards, Andrei Lepikhov