BUG #11642: Aggregate Functions like min, max return one row in case of no rows in table - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      11642
Logged by:          Jai Soni
Email address:      jai.soni@elbizsystems.com
PostgreSQL version: 9.3.0
Operating system:   Open Suse Linux 12.1
Description:

Aggregate Functions like min, max return one row in case of no rows in table
it should return 0 rows as it return while using normal field in select
query
below code will re-create the case

# create table dummy(fid integer);

# select * from dummy;
 fid
-----
(0 rows)

# select max(fid) from dummy;
 max
-----

(1 row)