X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2FAEC565A5 for ; Fri, 18 Mar 2005 21:05:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25431-02 for ; Fri, 18 Mar 2005 21:05:19 +0000 (GMT) Received: from mta08-winn.mailhost.ntl.com (smtpout16.mailhost.ntl.com [212.250.162.16]) by svr1.postgresql.org (Postfix) with ESMTP id A5E1F565E3 for ; Fri, 18 Mar 2005 21:05:17 +0000 (GMT) Received: from aamta02-winn.mailhost.ntl.com ([212.250.162.8]) by mta08-winn.mailhost.ntl.com with ESMTP id <20050318210517.CNJR928.mta08-winn.mailhost.ntl.com@aamta02-winn.mailhost.ntl.com> for ; Fri, 18 Mar 2005 21:05:17 +0000 Received: from [192.168.0.103] (really [213.105.102.236]) by aamta02-winn.mailhost.ntl.com with ESMTP id <20050318210517.LPJJ1289.aamta02-winn.mailhost.ntl.com@[192.168.0.103]> for ; Fri, 18 Mar 2005 21:05:17 +0000 Subject: Re: Consecutive row count query From: Leon Stringer To: pgsql-sql@postgresql.org In-Reply-To: <1111090884.22783.5.camel@localhost.localdomain> References: <1111090884.22783.5.camel@localhost.localdomain> Content-Type: text/plain Date: Fri, 18 Mar 2005 21:07:51 +0000 Message-Id: <1111180071.5252.3.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-1) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.906 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST X-Spam-Level: X-Archive-Number: 200503/264 X-Sequence-Number: 20743 > I wondered if anyone could answer the following question: Thanks for your responses, I think I'll just add the extra column in as Greg suggests. (BTW: I mean "unnecessary *denormalization*" which I hope is less odd!). Leon...