Hi On Wed, Oct 22, 2014 at 1:55 PM, Teodor Sigaev <teo...@sigaev.ru> wrote: > With patch it's possible to rewrite query with ranges > SELECT * FROM test_int4 WHERE i <@ '[-1, 1]'::int4range > and GIN index will support this query with single scan from -1 to 1.
Shouldn't this be implemented in a more generic manner? An ordinary btree index could very well support <@ queries too, but your patch only adds this capability to btree-gin. The documentation describes btree-gin as providing "GIN operator classes that implement B-tree equivalent behavior", but now the behavior diverges. Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
