X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D2FA49FB3A6 for ; Mon, 14 Aug 2006 03:46:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 79940-01-7 for ; Mon, 14 Aug 2006 06:45:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx00.ext.bfk.de (mx00.ext.bfk.de [217.29.46.125]) by postgresql.org (Postfix) with ESMTP id 47BC99FB51B for ; Mon, 14 Aug 2006 03:40:17 -0300 (ADT) Received: from fweimer by bfk.de with local id 1GCW7S-0002Y7-KL; Mon, 14 Aug 2006 08:40:14 +0200 To: Kyle Bateman Cc: pgsql-sql@postgresql.org Subject: Re: Using bitmap index scans-more efficient References: <44DF6582.4000806@actarg.com> From: Florian Weimer Date: Mon, 14 Aug 2006 08:40:14 +0200 In-Reply-To: <44DF6582.4000806@actarg.com> (Kyle Bateman's message of "Sun, 13 Aug 2006 11:46:42 -0600") Message-ID: <82mza77rch.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/95 X-Sequence-Number: 26053 * Kyle Bateman: > Any ideas about whether/how this can be done? If the project tree is fairly consistent, it's convenient to encode it using intervals instead of parent/child intervals. IIRC, Celko's "SQL for smarties" explains how to do this, and Kristian Koehntopp has written some PHP code to implement it. -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Durlacher Allee 47 tel: +49-721-96201-1 D-76131 Karlsruhe fax: +49-721-96201-99