Re: count(*) of zero rows returns 1

On Tue, Jan 15, 2013 at 5:47 AM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
> postgres=# select * from test_0_col_table ;
> --
> (200000 rows)

Interestingly, PostgreSQL 9.2 has regressed here. Not sure if we care,
but worth mentioning:

psql (9.2.2)

test=# select count(*) from foo1; count
----------10000000
(1 row)
Time: 632.907 ms

test=# select * from foo1;
(No rows)
Time: 1012.567 ms


Regards,
Marti