Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 653771337F09
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 17 Sep 2010 12:45:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 16997-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 17 Sep 2010 15:45:16 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp.go-wipex.it (mx1.go-wipex.it [89.202.235.7])
	by mail.postgresql.org (Postfix) with ESMTP id 335B61336473
	for <pgsql-sql@postgresql.org>; Fri, 17 Sep 2010 12:45:16 -0300 (ADT)
Received: from unipex-local-server (unipex.wipex [172.16.20.247])
	by smtp.go-wipex.it (Postfix) with ESMTP id D5C1F10B00AD;
	Fri, 17 Sep 2010 17:45:14 +0200 (CEST)
Received: from [192.168.1.103] (michele [192.168.1.103])
	by unipex-local-server (Postfix) with ESMTP id AC94B560001;
	Fri, 17 Sep 2010 17:45:14 +0200 (CEST)
Message-ID: <4C938D09.3050105@unipex.it>
Date: Fri, 17 Sep 2010 17:45:13 +0200
From: Michele Petrazzo - Unipex <michele.petrazzo@unipex.it>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.8.1b1) Gecko/20060724 Thunderbird/2.0a1 Mnenhy/0.7.4.0
MIME-Version: 1.0
To: Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
CC: pgsql-sql@postgresql.org
Subject: Re: all the table values equal
References: <4C93803A.4080706@unipex.it>
	<438B32316EF6496D9641819BA16447A2@marktestcr.marktest.pt>
In-Reply-To: <438B32316EF6496D9641819BA16447A2@marktestcr.marktest.pt>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201009/50
X-Sequence-Number: 34581

Oliveiros d'Azevedo Cristina ha scritto:
> Howdy , Michele,
>
> Give this a try
>
> SELECT id_user FROM t_your_table WHERE datetime BETWEEN A -- plug
> here beginning of interval AND B -- and end here GROUP BY id_user
> HAVING COUNT(*) = -SUM(value)
>
> Then tell me if it gives you what you want


Thanks,
it works, but... it's really a trickle that exploits the value -1 if I
understand how its work.
If there is another value where look for? Example 13?

Thanks