hi,
I am having a problem with group-by clause/aggreate functions... Following
is the query which runs well in mysql....
query :
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,
dir;
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,
..shabala