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
Also, I noticed that patch haven't regression tests.
BTW, those tests need to pay special attention to inclusive vs exclusive
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
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: