Use of GROUP BY - Mailing list pgsql-general

From Mihai Gheorghiu
Subject Use of GROUP BY
Date
Msg-id 00ce01c26a54$2a536220$6e646464@New6.Travel
Whole thread Raw
List pgsql-general
PG7.2.1 on RH7.3
There is no 1234 value in field1.
select sum(amount) from table1 where field1 = 1234;
 sum
-----

(1 row)

select sum(amount) from table1 where field1 = 1234 group by field1;
 sum
-----
(0 rows)

If GROUP BY should always be used in statements using aggregate functions,
why don't I get an error?

Thank you all.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Error with sequences, "sequence was re-created"
Next
From: "Oleg Lebedev"
Date:
Subject: Re: Use of GROUP BY