Re: Index usage for elem-contained-by-const-range clauses

On 3/10/17 8:29 AM, Alexander Korotkov wrote:
> That's cool idea. But I would say more. Sometimes it's useful to
> transform "intcol between x and y" into "intcol <@ 'x,y'::int4range".
> btree_gin supports "intcol between x and y" as overlap of "intcol >= x"
> and "intcol <= y". That is very inefficient. But it this clause would
> be transformed into "intcol <@ 'x,y'::int4range", btree_gin could handle
> this very efficient.

That's certainly be nice as well, but IMHO it's outside the scope of
this patch to accomplish that.

BTW, while we're wishing for things... Something else that would be nice
is if there was a way to do these kind of transforms without hacking the
backend...

> Also, I noticed that patch haven't regression tests.

BTW, those tests need to pay special attention to inclusive vs exclusive
bounds.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)