X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id B14BF30EB78
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 15 Jun 2003 08:22:41 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 97350-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 15 Jun 2003 05:22:31 -0300 (ADT)
Received: from smtp.voxline.ro (unknown [194.176.186.2])
	by svr1.postgresql.org (Postfix) with ESMTP id CDCDB30E7D4
	for <pgsql-sql@postgresql.org>; Sun, 15 Jun 2003 05:22:30 -0300 (ADT)
Received: from 127.0.0.1 (localhost [127.0.0.1])
	by mailbox.voxline.ro (Postfix) with SMTP id DF18D288A7
	for <pgsql-sql@postgresql.org>; Sun, 15 Jun 2003 11:27:58 +0300 (EEST)
Received: from webnew.voxline.ro (webnew.voxline.ro [194.176.186.9])
	by smtp.voxline.ro (Postfix) with ESMTP id A8E50288A0
	for <pgsql-sql@postgresql.org>; Sun, 15 Jun 2003 11:27:58 +0300 (EEST)
Received: (from webpub@localhost)
	by webnew.voxline.ro (8.11.6/8.11.6) id h5F81qj32555;
	Sun, 15 Jun 2003 11:01:52 +0300
Date: Sun, 15 Jun 2003 11:01:52 +0300
From: vali@voxline.ro
Message-Id: <200306150801.h5F81qj32555@webnew.voxline.ro>
X-Authentication-Warning: webnew.voxline.ro: webpub set sender to
	vali@voxline.ro using -f
To: pgsql-sql@postgresql.org
Cc: 
Subject: Where of an aggregate
X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME,
	RCVD_IN_RFCI, X_AUTH_WARNING
X-Spam-Level: *
X-Archive-Number: 200306/134
X-Sequence-Number: 13892

HI!
Try this

select c.traffic from
(select sum(bytes) as traffic
    from traffic_table
group by ip) c where c.traffic<(100*1024*1024);