On 10/11/14, 9:31 AM, jai(dot)soni(at)elbizsystems(dot)com wrote:
> 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
According to whom?
This behaviour is well defined in the SQL standard and documented for
example here:
http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-GROUPBY
"Aggregate functions, if any are used, are computed across all rows
making up each group, producing a separate value for each group (whereas
without GROUP BY, an aggregate produces a single value computed across
all the selected rows)."
.marko