Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fACFhQm11210 for ; Mon, 12 Nov 2001 10:43:27 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD9501247.dip.t-dialin.net [217.80.18.71]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fACFh4215430; Mon, 12 Nov 2001 16:43:04 +0100 Subject: Re: integer attribute 1672 != 1672 From: Markus Bertheau To: Haller Christoph , postgres sql list In-Reply-To: <200111121505.QAA23169@rodos> References: <200111121505.QAA23169@rodos> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.99.0 (Preview Release) Date: 12 Nov 2001 16:55:51 +0100 Message-Id: <1005580552.31390.10.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200111/160 X-Sequence-Number: 5544 > AFAIK if you use an aggregate function on a column and > group by this column the result is undefined. > Re-think what you want to query. For each view there is a row in partner_views (the partner_id and a timestamp). I want to know how many views each partner has. I think the query is semantically correct. Markus Bertheau