Postgres Pro
Downloads
Home   >   mailing lists

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

From Geoff Winkless
Subject Re: select count(*);
Date
Msg-id CAEzk6fdp-F+PQoe7RmWrsAPj67jKLgixpEQ6NM_Ap_DDLWUd3Q@mail.gmail.com
Whole thread Raw
In response to Re: select count(*);  (Yves Dorfsman <yves@zioup.com>)
List pgsql-general
Tree view
On 11 June 2015 at 15:35, Yves Dorfsman <yves@zioup.com> wrote:
On 2015-06-11 08:20, Geoff Winkless wrote:
> On 11 June 2015 at 15:17, Marc Mamin <M.Mamin@intershop.de
> <mailto:M.Mamin@intershop.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)


​As expected.

=#
​
SELECT
 1 WHERE 1=0;
 ?column?
----------
(0 rows)

​Geoff​

pgsql-general by date:

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