Do I just not understand count()? - Mailing list pgsql-general

From Ben
Subject Do I just not understand count()?
Date
Msg-id Pine.LNX.4.30.0204081122230.9115-100000@gilgamesh.eos.SilentMedia.com
Whole thread Raw
Responses Re: Do I just not understand count()  (Clinton Adams <clinton@vote-smart.org>)
List pgsql-general
If I have the table t defined as:

 a
---
 1
 1
 2


and I say:

select count(a=1) from t;

should it give me 1 or 2 as a result? I'm getting 2, and I'd think I
should get 1....


pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: Tcl_CreateSlave error (pg 7.1.2, RH 7.2)
Next
From: "Gregory Wood"
Date:
Subject: Re: Do I just not understand count()?