Re: question about count(b) where b is a custom type

From: "Pollard, Mike" <mpollard(at)cincom(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: question about count(b) where b is a custom type
Date: 2005-11-16 12:54:25
Message-ID: 6418CC03D0FB1943A464E1FEFB3ED46B01B220AF@im01.cincom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2005-11-16 13:12:42 Re: question about count(b) where b is a custom type
Previous Message Hannu Krosing 2005-11-16 12:42:39 Re: question about count(b) where b is a custom type