Result from Having count

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

Responses

Browse pgsql-general by date

  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?