Pollard, Mike wrote:
Firstly, if you just want a count, what's wrong with count(1) or count(*).Because unless the column does not allow nulls, they will not return the same value.
Ah, but in the example given the column was being matched against a value, so nulls were already excluded.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
