Message-ID: <4C98C48D.1070103@unipex.it>
Date: Tue, 21 Sep 2010 16:43:25 +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>
	<4C938D09.3050105@unipex.it>
	<81C545E3469E4DF58720C282A469E78A@marktestcr.marktest.pt>
	<4C9868AB.6050200@unipex.it>
	<5E43A989C2FA4F60B146DAC454BAA21D@marktestcr.marktest.pt>
In-Reply-To: <5E43A989C2FA4F60B146DAC454BAA21D@marktestcr.marktest.pt>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Oliveiros d'Azevedo Cristina ha scritto:
>
> OK, So, analysing your new question, the time interval is still
> important? Or no longer?

It's important but simple to translate into sql, so I remove it from my 
question.

> So writting your query in english : "I want all users that don't change
> "value" and their value is equal to x ?"
>

Yes. All the users that have only one value into the "value" column and 
that value is NN.

> Or will you need to find all the users that don't change value with just
> one query? And the query would return something like
>
> id_user | value
> 2 | -1
> 4| 3
>


A right result for me, based by my data, will be:

// choosing -1 like value
id_user
2

// choosing 3 like value
id_user
4

and if I add to the table:
id_user | value | datetime
5 | -1  | xxx
5 | -1  | xxx +1


// choosing -1 like value
id_user
2
5

Thanks,
Michele