group by

Поиск
Список
Период
Сортировка
От Ewald Geschwinde
Тема group by
Дата
Msg-id 3C4479C9.2050707@geschwinde.net
обсуждение исходный текст
Ответы Re: group by  ("Josh Berkus" <josh@agliodbs.com>)
Re: group by  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
I have a problem whith group by and aliases

select s1.channelname as channelname, s1.id as channelid,
count(*) as anz from mgw_news n left join mgw_news_channels s1 on
n.channelid = s1.id group by channelid, channelname order by channelid,
channelname


this runs under mysql and postgresql seems not to accept aliases in
group by

cause when i'm changing channelid to s1.id it works perfectly

is anyone working on that?
I didn't see this in the TODO list

With whom can I talk about this problem?

regards Ewald Geschwinde



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

Предыдущее
От: "Jules Alberts"
Дата:
Сообщение: Re: inheritance and audit columns
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: group by