Do I just not understand count()?
Ben Chobot <bench@silentmedia.com>
From: Ben <bench@silentmedia.com>
To: <pgsql-general@postgresql.org>
Date: 2002-04-08T18:25:43Z
Lists: 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....