Postgres Pro
Downloads
Home   >   mailing lists

Re: select count(*); - Mailing list pgsql-general

From Marc Mamin
Subject Re: select count(*);
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D8828BE8002@jenmbs01.ad.intershop.net
Whole thread Raw
In response to Re: select count(*);  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: select count(*);  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: select count(*);  (Francisco Olarte <folarte@peoplecall.com>)
Re: select count(*);  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
>>That's the point. * has no meaning without FROM


>But COUNT(*) 
>
>does have meaning - it means "the number of rows".

which rows? :-)

> It's not counting the number of columns in the row, so postgres doesn't need to know what columns exist in the row to
returna row count.
 

>Geoff

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: select count(*);
Next
From: Asma Riyaz
Date:
Subject: GCC error and libmpfr.so.4 not found