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.

More Content by Onsi Fakhouri
Previous
Social Strategy, not Social Media
Social Strategy, not Social Media

SoLoMo is a new buzzword coined by Venture Capitalist John Doerr that combines three powerful marketing str...

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...