Re: all the table values equal - Mailing list pgsql-sql

From Michele Petrazzo - Unipex
Subject Re: all the table values equal
Date
Msg-id 4C938D09.3050105@unipex.it
Whole thread Raw
In response to Re: all the table values equal  ("Oliveiros d'Azevedo Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: all the table values equal
Next
From: Jann Röder
Date:
Subject: Re: Table returning functions