Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C93AE1337EED for ; Thu, 16 Sep 2010 11:57:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 26602-01-7 for ; Thu, 16 Sep 2010 14:57:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 82B441337FB2 for ; Thu, 16 Sep 2010 11:56:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o8GEuUMB012593; Thu, 16 Sep 2010 10:56:30 -0400 (EDT) To: Alanoly Andrews cc: "'pgsql-admin@postgresql.org'" Subject: Re: Bidirectional index traversal In-reply-to: <09B23E7BF70425478C1330D893A722C602FEC01A2C@MailSVR.invera.com> References: <09B23E7BF70425478C1330D893A722C602FEC01A2C@MailSVR.invera.com> Comments: In-reply-to Alanoly Andrews message dated "Thu, 16 Sep 2010 10:39:02 -0400" Date: Thu, 16 Sep 2010 10:56:30 -0400 Message-ID: <12592.1284648990@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/87 X-Sequence-Number: 35631 Alanoly Andrews writes: > I'd like to know whether Postgres (8.4) supports bidirectional traversal of indexes. If you defined exactly what you meant by that, you might get useful answers. There are some features in there that might be what you mean, or then again maybe not. regards, tom lane