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,
this runs under mysql and postgresql seems not to accept aliases in
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 by date
|Next:||From: Josh Berkus||Date: 2002-01-15 19:55:47|
|Subject: Re: group by|
|Previous:||From: John Burski||Date: 2002-01-15 15:42:25|
|Subject: Re: Cant find libpq-fe.h|