Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id D36E56336A8
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 22 Jul 2010 11:18:58 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 85990-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 22 Jul 2010 14:18:49 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id 784056334F3
	for <pgsql-sql@postgresql.org>; Thu, 22 Jul 2010 11:18:50 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Obwbk-0004FR-TL
	for pgsql-sql@postgresql.org; Thu, 22 Jul 2010 16:18:44 +0200
Received: from g231144196.adsl.alicedsl.de ([92.231.144.196])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 22 Jul 2010 16:18:44 +0200
Received: from tim by g231144196.adsl.alicedsl.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 22 Jul 2010 16:18:44 +0200
X-Injected-Via-Gmane: http://gmane.org/
Mail-Followup-To: pgsql-sql@postgresql.org
To: pgsql-sql@postgresql.org
From: Tim Landscheidt <tim@tim-landscheidt.de>
Subject: Re: grouping subsets
Date: Thu, 22 Jul 2010 14:18:34 +0000
Organization: <URI:http://www.tim-landscheidt.de/>
Lines: 13
Message-ID: <m3iq47txad.fsf@passepartout.tim-landscheidt.de>
References: <i28ubc$ie9$1@dough.gmane.org>
	<6FDFC090436D4DA98EBB99D0757B5930@marktestcr.marktest.pt>
	<4C4846CE.4070701@diplan.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: g231144196.adsl.alicedsl.de
Mail-Copies-To: never
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
Cancel-Lock: sha1:xSOrB+IzDh63s3DGt3o7cg39wp0=
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.011 tagged_above=-5 required=5
	tests=BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201007/95
X-Sequence-Number: 34408

Rainer Stengele <rainer.stengele@diplan.de> wrote:

> yes, the date is always incremented - but anyway the date
> column is not really the point! Actually the first tow
> columns are relevant. I want them gouped together as
> indicated, adding up column 1 in the blocks with identical
> second column, but not adding up over all the rows.
> [...]

If the date column wasn't relevant, how would you group the
first two columns?

Tim