From: | "omid omoomi" <oomoomi(at)hotmail(dot)com> |
---|---|
To: | aturchin(at)chip(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: COUNTs don't add up |
Date: | 2001-07-23 20:34:13 |
Message-ID: | F30XLFfJNwPmxd22RQY00003c43@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi ,
try this :
select species2, count(*) from homol_loclink group by species2;
it will show you.
Regards
Omid
>From: Alexander Turchin <aturchin(at)chip(dot)org>
>To: PostgreSQL Mailing List <pgsql-general(at)postgresql(dot)org>
>Subject: [GENERAL] COUNTs don't add up
>Date: Mon, 23 Jul 2001 15:32:04 -0400
>
>Hello all,
>
>I have a database where (I believe; the database was not made by me) one
>of the columns contains only two values: A or B. When I count all the
>rows in the database I get X; when I count the rows containing A or B in
>that column I get X-2; when I count the rows containing neither A nor B
>I get 0. Any explanation (hopefully, again, I am doing something wrong
>:)?
>
>The actual queries are found below.
>
>Thanks!
>
>Alex
>
>aturchin=# SELECT COUNT(*) FROM homol_loclink
>aturchin-# WHERE (species2 = 'Mus musculus') OR
>aturchin-# (species2 = 'Rattus norvegicus');
> count
>-------
> 7110
>(1 row)
>
>aturchin=# SELECT COUNT(*) FROM homol_loclink;
> count
>-------
> 7112
>(1 row)
>
>aturchin=# SELECT COUNT(*) FROM homol_loclink
>aturchin-# WHERE (species2 <> 'Mus musculus') AND
>aturchin-# (species2 <> 'Rattus norvegicus');
> count
>-------
> 0
>(1 row)
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
From | Date | Subject | |
---|---|---|---|
Next Message | Len Morgan | 2001-07-23 20:37:55 | Re: COUNTs don't add up |
Previous Message | Alexander Turchin | 2001-07-23 20:27:34 | Re: COUNTs don't add up |