Re: select count(*);

From: Yves Dorfsman <yves(at)zioup(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: select count(*);
Date: 2015-06-11 14:35:11
Message-ID: 55799C9F.6040802@zioup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2015-06-11 08:20, Geoff Winkless wrote:
> On 11 June 2015 at 15:17, Marc Mamin <M(dot)Mamin(at)intershop(dot)de
> <mailto:M(dot)Mamin(at)intershop(dot)de>>wrote:
>
> >But COUNT(*)
> >
> >does have meaning - it means "the number of rows".
>
> which rows? :-)
>
>
> ​The number of rows in the query, as well you know :)

But interestingly

postgres=# select count(*) where 1=0;
count
-------
0
(1 row)

--
http://yves.zioup.com
gpg: 4096R/32B0F416

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2015-06-11 14:39:59 Re: select count(*);
Previous Message Geoff Winkless 2015-06-11 14:34:22 Re: GCC error and libmpfr.so.4 not found