On Tue, 11 Oct 2005, Rick Schumeyer wrote: > I'm not sure what I was thinking, but I tried the following query in pg: > > SELECT * FROM t GROUP BY state; > > pg returns an error. > > Mysql, OTOH, returns the first row for each state. (The first row with > "AK", the first row with "PA", etc.) > > I'm no SQL expert, but it seems to me that the pg behavior is correct, and > the mysql result is just weird. Am I correct?
In your case, it sounds like the mysql result is wrong. I believe SQL99 would allow it if the other columns were functionally dependant upon state (as there'd by definition only be one value for the other columns per group). ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
