Home > mailing lists

Re: select vs. select count - Mailing list pgsql-sql

From	Peter Eisentraut
Subject	Re: select vs. select count
Date	March 27, 2007 14:20:20
Msg-id	200703271620.10123.peter_e@gmx.net Whole thread Raw
In response to	select vs. select count ("Claus Guttesen" <kometen@gmail.com>)
List	pgsql-sql

Tree view

Claus Guttesen wrote:
> Why does select and select(count) produce two different results?

count(expression) only counts nonnull values.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-sql by date:

From: "A. Kretschmer"
Date: 27 March 2007, 13:36:57
Subject: Re: Foreign Unique Constraint

From: "Jon Horsman"
Date: 27 March 2007, 14:27:37
Subject: Re: Foreign Unique Constraint

Re: select vs. select count - Mailing list pgsql-sql

Previous

Next