Chris <dmagick@xxxxxxxxx> writes: > eg mysql doesn't force you to group by all columns being selected - I > can do: > select field1, field2, field3 from table group by field1; > and have it valid in mysql (but of course postgres will tell you it's > not valid and need to add grouping for field2 and field3). Actually, that *is* legal per SQL99 under certain specified conditions (eg if field1 is a primary key for table). We haven't gotten around to implementing SQL99's relaxed rules for grouping --- we're still basically doing what SQL92 says. Now the full SQL99 spec for this is pretty hairy, but I'd bet lunch that mysql supports only the easier cases such as group-by-primary-key. We might be able to cover the same cases they do without too much sweat ... does anyone want to dig in and determine exactly which cases they cover? regards, tom lane
