Greg, You'll have to pardon me...
I saw this comment:
"I don't see why you think people stumble on this by accident.
I think it's actually an extremely common need."
Which, if referring to the ability to have items in the select that do
not
need to be included in the group, (excluding constants and the like)
is just silly.
OTOH, if you're all poking fun at a mysql bug that they try to pass
off as a feature, then yes, I'm a clod and I missed that the first time
around :)
Regards, Anthony
-----Original Message-----
From: gsstark@mit.edu [mailto:gsstark@mit.edu]
Sent: Wednesday, October 12, 2005 11:43 PM
To: Anthony Molinaro
Cc: Tom Lane; Greg Stark; Scott Marlowe; Stephan Szabo; Rick Schumeyer;
pgsql-sql@postgresql.org
Subject: Re: [SQL] pg, mysql comparison with "group by" clause
"Anthony Molinaro" <amolinaro@wgen.net> writes:
> By changing the values in the select/group by you are changing
> Group! How can you arbitrarily add or exclude a column?
> You can't do it.
Go back and reread the previous posts again. You missed the whole point.
--
greg