I am having a problem with group-by clause/aggreate functions... Following
is the query which runs well in mysql....
select min(rt), cnt, link_name, dir, t_rate, rate from fg_table where
obj_type = ? and obj_id = ? and rt > ? and rt_type = 'u' group by link_name,
but when i run it in postgres i get follwing errors:
DBD::Pg::st execute failed: ERROR: column "fg_table.cnt" must appear in the
GROUP BY clause or be used in an aggregate function
same for the t_rate,rate fields in SELECT clause which are not included in
the GROUP BY clause.
can anyone please guide me?
thanks n regards,
pgsql-novice by date
|Next:||From: Bastiaan Olij||Date: 2008-09-09 22:54:55|
|Subject: Re: problem with group-by clause/aggreate functions|
|Previous:||From: Григорий Никоноров||Date: 2008-09-09 08:15:06|
|Subject: Re: Problem wth postgresql.conf|