Skip site navigation (1) Skip section navigation (2)

problem with group-by clause/aggreate functions

From: "Shabala Deshpande" <de(dot)shabala(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: problem with group-by clause/aggreate functions
Date: 2008-09-09 09:44:53
Message-ID: 16b7e2640809090244m3668c7c0kbbdb2f92e0800621@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Bastiaan OlijDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group