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