Re: Functional dependencies and GROUP BY - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Functional dependencies and GROUP BY
Date
Msg-id 20100608014124.GJ21875@tamriel.snowman.net
Whole thread Raw
In response to Functional dependencies and GROUP BY  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Functional dependencies and GROUP BY  (Rob Wultsch <wultsch@gmail.com>)
List pgsql-hackers
* Peter Eisentraut (peter_e@gmx.net) wrote:
> This is frequently requested by MySQL converts (and possibly others).

I'd certainly love to see it- but let's not confuse people by implying
that it would actually act the way MySQL does.  It wouldn't, because
what MySQL does is alot closer to 'distinct on' and is patently insane
to boot.  Again, I'd *love* to see this be done in PG, but when we
document it and tell people about it, *please* don't say it's similar in
any way to MySQL's "oh, we'll just pick a random value from the columns
that aren't group'd on" implementation.

> At this point, this patch could use some review and testing with unusual
> queries that break my implementation. ;-)

I'll give it a shot... :)
Thanks!
    Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Functional dependencies and GROUP BY
Next
From: KaiGai Kohei
Date:
Subject: Re: [PATCH] Fix leaky VIEWs for RLS