Re: select count(*);

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "'Geoff Winkless'" <pgsqladmin(at)geoff(dot)dj>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: select count(*);
Date: 2015-06-11 14:17:17
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828BE8002@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>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 return a row count.

>Geoff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Asma Riyaz 2015-06-11 14:20:43 GCC error and libmpfr.so.4 not found
Previous Message Geoff Winkless 2015-06-11 14:13:06 Re: select count(*);