Re: [GENERAL] select count(*);

[Geoff Winkless]

On 11 June 2015 at 15:35, Yves Dorfsman <y...@zioup.com> wrote:

> On 2015-06-11 08:20, Geoff Winkless wrote:
> > On 11 June 2015 at 15:17, Marc Mamin <m.ma...@intershop.de
> > <mailto:m.ma...@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​