Re: integer attribute 1672 != 1672

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Haller Christoph <ch(at)rodos(dot)fzk(dot)de>, postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: integer attribute 1672 != 1672
Date: 2001-11-12 15:55:51
Message-ID: 1005580552.31390.10.camel@entwicklung01.cenes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-12 15:59:20 Re: integer attribute 1672 != 1672
Previous Message Markus Bertheau 2001-11-12 15:52:40 Re: integer attribute 1672 != 1672