Re: Functional dependencies and GROUP BY

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Functional dependencies and GROUP BY
Дата
Msg-id 20100608014124.GJ21875@tamriel.snowman.net
обсуждение исходный текст
Ответ на Functional dependencies and GROUP BY  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Functional dependencies and GROUP BY  (Rob Wultsch <wultsch@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Functional dependencies and GROUP BY
Следующее
От: KaiGai Kohei
Дата:
Сообщение: Re: [PATCH] Fix leaky VIEWs for RLS