Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA16279 for postgres-redist; Wed, 14 Sep 1994 07:28:19 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199409141428.HAA16279@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from unitrix.utr.ac.za (unitrix.utr.ac.za [192.96.20.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA16269 for ; Wed, 14 Sep 1994 07:28:12 -0700 Received: by unitrix.utr.ac.za (Smail3.1.28.1 #1) id m0qkvAW-0001w2C; Wed, 14 Sep 94 16:18 GMT Message-Id: From: ccnp@unitrix.utr.ac.za (Neil Parker) Subject: Group By To: postgres@postgres.Berkeley.EDU (Postgres Database) Date: Wed, 14 Sep 1994 16:18:40 +0200 (GMT) X-Mailer: ELM [version 2.4 PL11] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 407 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 14 Sep 94 07:28:19 -0700 Resent-XMts: smtp Hi Is it possible to do this using postgres postquel ? select avg (Qty) from parts group by supplier Qty and supplier are attributes in the parts table. Neil -- Neil Parker Just * Computer Centre, University of Transkei visiting * Pvt Bag X1 Umtata . Tel (0471)-3022461 * this Email: ccnp@unitrix.utr.ac.za * Planet ! ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================