Support functions for range types

2022-09-25 Thread Kim Johan Andersson
I was surprised by the poor performance when I first tried to use range types. What I expected was that the following two queries would be equivalent (see attached script): postgres=# EXPLAIN ANALYZE SELECT some_number FROM integer_test WHERE some_number BETWEEN -2 AND 2; QUERY PLAN

Re: Support functions for range types

2022-09-25 Thread Kim Johan Andersson
itable for the index, then I guess it won't be possible to make a really useful support function for range types. Thanks for the input. Regards, Kim Johan Andersson