No really, you have to pick *one*

November 29, 2011 Onsi Fakhouri

Ask for Help

“Postgres SELECT * GROUP BY insists that all selected fields must either appear in the GROUP BY or be aggregated.”

Many agreed that this is, in fact, how a database should behave and that MySQL’s leniency on this matter is faulty. If you select a field that you don’t group by, you must tell Postgres how to combine the sub-set of values that fall in a given group into a single result (should it take the max? the min? the mean? the most purple?).

About the Author

Onsi Fakhouri

Onsi Fakhouri is the Senior Vice President, Cloud R&D of Pivotal.

Previous
[SF] 11/30/2011: 30 Days has Movember
[SF] 11/30/2011: 30 Days has Movember

Ask for Help "Is there a good JS/HTML code editor that will expand to fix the contents?" A team is ...

Next
Deploy to Any Cloud Foundry Target with eXo Cloud IDE
Deploy to Any Cloud Foundry Target with eXo Cloud IDE

The free eXo Cloud IDE now supports Cloud Foundry deployments including Cloudfoundry.com, Micro Cloud Found...

SpringOne Platform 2019 Presentations

Watch Now