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