BUG #11642: Aggregate Functions like min, max return one row in case of no rows in table

From: jai(dot)soni(at)elbizsystems(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11642: Aggregate Functions like min, max return one row in case of no rows in table
Date: 2014-10-11 07:31:09
Message-ID: 20141011073109.7983.80503@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11642
Logged by: Jai Soni
Email address: jai(dot)soni(at)elbizsystems(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marko Tiikkaja 2014-10-11 09:14:35 Re: BUG #11642: Aggregate Functions like min, max return one row in case of no rows in table
Previous Message dj 2014-10-11 05:04:03 BUG #11641: ./configure fails with mingw gcc 9.4beta3