From: Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
To: Michele Petrazzo - Unipex <michele.petrazzo@unipex.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: all the table values equal
Date: Tue, 21 Sep 2010 16:02:22 +0100
Message-ID: <D927FA316ABB44BE8F91E892454BFAA4@marktestcr.marktest.pt> (raw)
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>
<4C98C48D.1070103@unipex.it>
>
> Yes. All the users that have only one value into the "value" column and
> that value is NN.
Understood. Try the query from the previous mail, adding the clause WHERE
"value" = NN as I did explain.
>
>> 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
Understood. From the query I sent you just eliminate the "value" column
from the select list, as you are not interested in it.
> Thanks,
> Michele
Best,
Oliver
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliveiros.cristina@marktest.pt, michele.petrazzo@unipex.it
Subject: Re: all the table values equal
In-Reply-To: <D927FA316ABB44BE8F91E892454BFAA4@marktestcr.marktest.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox