Re: Pushing ScalarArrayOpExpr support into the btree index AM - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Pushing ScalarArrayOpExpr support into the btree index AM
Date
Msg-id 15387.1318779217@sss.pgh.pa.us
Whole thread Raw
In response to Re: Pushing ScalarArrayOpExpr support into the btree index AM  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
Noah Misch <noah@leadboat.com> writes:
> On Sat, Oct 15, 2011 at 02:58:45PM -0400, Tom Lane wrote:
>> [algorithm for a regular index scan satisfying "key IN (...)"]

> Sounds sensible.  The algorithm applies to more than ScalarArrayOpExpr; is it
> not the ability to handle an OR'ed list of ScanKey instead of an AND'ed one?

No, because it's restricted to all the elements having the same operator
and same index column; it's not a generic OR.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] Fix Leaky View Problem
Next
From: Jan Urbański
Date:
Subject: proposal: set GUC variables for single query