Seems like it'll take lots of time while i join the club :(

ixremedy · #1 (**permalink**) 06-13-03, 08:43

Hello all!
Well i come up with somehow another problem with queries in Postgre.
When i pass the following query:
SELECT ip_networks.chunk_id,ip_networks.ip_mask, SUM(ip_allocations.ip_mask) FROM ip_networks,ip_allocations WHERE ip_allocations.chunk_id = ip_networks.chunk_id AND ip_networks.ip_mask >= '15';

i get this:
ERROR: Attribute ip_networks.chunk_id must be GROUPed or used in an aggregate function

So the question comes out how do i rewrite this query so as to get what i want?

Inner_Join · #2 (**permalink**) 06-28-03, 08:26

Quote:

Originally posted by ixremedy
Hello all!
Well i come up with somehow another problem with queries in Postgre.
When i pass the following query:
SELECT ip_networks.chunk_id,ip_networks.ip_mask, SUM(ip_allocations.ip_mask) FROM ip_networks,ip_allocations WHERE ip_allocations.chunk_id = ip_networks.chunk_id AND ip_networks.ip_mask >= '15';

i get this:
ERROR: Attribute ip_networks.chunk_id must be GROUPed or used in an aggregate function

So the question comes out how do i rewrite this query so as to get what i want?

Code:

 
SELECT ip_networks.chunk_id,ip_networks.ip_mask, SUM(ip_allocations.ip_mask)
FROM ip_networks,ip_allocations
WHERE ip_allocations.chunk_id = ip_networks.chunk_id AND ip_networks.ip_mask >= '15'
GROUP BY ip_networks.chunk_id,ip_networks.ip_mask