Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8E4F19FB324 for ; Tue, 6 Feb 2007 06:15:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 92218-01 for ; Tue, 6 Feb 2007 06:14:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 25ABC9FB321 for ; Tue, 6 Feb 2007 06:14:57 -0400 (AST) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 0A47573B84; Tue, 6 Feb 2007 09:38:47 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id BE002274053; Tue, 6 Feb 2007 09:38:47 +0000 (GMT) Message-ID: <45C84CA7.2020805@archonet.com> Date: Tue, 06 Feb 2007 09:38:47 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: "Hiltibidal, Robert" Cc: pgsql-sql@postgresql.org Subject: Re: Index ANDing & Index ORing References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/49 X-Sequence-Number: 27383 Hiltibidal, Robert wrote: > Does postgres have support for index ANDing and index ORing? Well, 8.1+ will create an on-the-fly bitmap for x=1 AND y=2 type of queries. What were you thinking for ORing? -- Richard Huxton Archonet Ltd