Postgres Pro
Downloads
Home   >   mailing lists

Re: question about count(b) where b is a custom type - Mailing list pgsql-hackers

From Pollard, Mike
Subject Re: question about count(b) where b is a custom type
Date
Msg-id 6418CC03D0FB1943A464E1FEFB3ED46B01B220AF@im01.cincom.com
Whole thread Raw
In response to question about count(b) where b is a custom type  (Grzegorz Jaskiewicz <gj@pointblue.com.pl>)
Responses Re: question about count(b) where b is a custom type  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
Tree view 
> 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.

Mike Pollard
SUPRA Server SQL Engineering and Support
Cincom Systems, Inc.
--------------------------------Better to remain silent and be thought a fool than to speak out and
remove all doubt.        Abraham Lincoln

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: question about count(b) where b is a custom type
Next
From: Richard Huxton
Date:
Subject: Re: question about count(b) where b is a custom type