group by

From: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: group by
Date: 2002-01-15 18:49:45
Message-ID: 3C4479C9.2050707@geschwinde.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-01-15 19:55:47 Re: group by
Previous Message John Burski 2002-01-15 15:42:25 Re: Cant find libpq-fe.h