pg, mysql comparison with "group by" clause

Поиск
Список
Период
Сортировка
От Rick Schumeyer
Тема pg, mysql comparison with "group by" clause
Дата
Msg-id 001001c5cea8$77cabc90$0300a8c0@dell8200
обсуждение исходный текст
Ответ на Re: question re. count, group by, and having  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg, mysql comparison with "group by" clause
Re: pg, mysql comparison with "group by" clause
Список pgsql-sql
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?



В списке pgsql-sql по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: SEVEN cross joins?!?!?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: pg, mysql comparison with "group by" clause