From: Michele Petrazzo - Unipex <michele.petrazzo@unipex.it>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: all the table values equal
Date: Fri, 17 Sep 2010 16:50:34 +0200
Message-ID: <4C93803A.4080706@unipex.it> (raw)
Hi list,
this is a Friday afternoon question... :)
I have a table like this:
id_user | value | datetime
1 | 1 | xxx
1 | 2 | xxx+1
1 | -1 | xxx+2
2 | -1 | xxx
2 | -1 | xxx+1
3 | 4 | xxx
3 | 10 | xxx+1
I'm trying to create a query that say me which id_user, inside a
interval of time, has all the values -1
The part if the interval it's not a problem, but I'm fighting with the
aggregate...
Someone?
Thanks,
Michele
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: michele.petrazzo@unipex.it
Subject: Re: all the table values equal
In-Reply-To: <4C93803A.4080706@unipex.it>
* 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