Re: Pushing ScalarArrayOpExpr support into the btree index AM

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Pushing ScalarArrayOpExpr support into the btree index AM
Date: 2011-10-16 15:33:37
Message-ID: 15387.1318779217@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Noah Misch <noah(at)leadboat(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Urbański 2011-10-16 15:44:57 proposal: set GUC variables for single query
Previous Message Kohei KaiGai 2011-10-16 08:46:04 Re: [v9.2] Fix Leaky View Problem