From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Result from Having count |
Date: | 2012-08-23 07:52:48 |
Message-ID: | d36f1787f53cc2fdafe614ada46437e8@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello ppl,
I try to make query and see how many ids have more then one row.
few records is:
ids | val | some
a | 1 | x
a | 1 | v
b | 1 | x
b | 2 | c
I focus on ids and val with:
SELECT ids, val FROM table WHERE ids = 'a' GROUP BY ids, val HAVING
COUNT(ids) > 1;
and result is:
ids | val
a | 1
Well in this condition pgsql shold not return me positive result
because on documentation I read having count work on group clause,
and when I group these two records based on ids = 'a' they become to
one row and my condition is if the result after grouping is greeter then
1.
I use postgresql 9.1.4 x64
Any one can tell me what I miss ?
Regards,
Hristo Simeonov
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Lanitz | 2012-08-23 08:11:46 | Re: Result from Having count |
Previous Message | Martin French | 2012-08-23 07:22:08 | Re: At what point does a big table start becoming too big? |