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 WAA23206 for postgres-redist; Wed, 14 Sep 1994 22:29:14 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199409150529.WAA23206@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 WAA23195 for ; Wed, 14 Sep 1994 22:27:03 -0700 Received: by unitrix.utr.ac.za (Smail3.1.28.1 #1) id m0ql9CH-0001swC; Thu, 15 Sep 94 07:17 GMT Message-Id: From: ccnp@unitrix.utr.ac.za (Neil Parker) Subject: Re: Group By (fwd) To: postgres@postgres.Berkeley.EDU (Postgres Database) Date: Thu, 15 Sep 1994 07:17:25 +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: 692 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 14 Sep 94 22:29:14 -0700 Resent-XMts: smtp Hi again In response to my question re a 'Group By' query, Guy R. Thomas writes: > From: "Guy R. Thomas" > > You can do something like that, > > retrieve ( average = int2ave{parts.Qty}, parts.supplier ) sort by > supplier > I submitted a query like this via spog and it came back with: FATAL: no response from backend: detected in dump_data Is this a program bug ? ( I have PG v 4.2 running on Linux 1.0 ) 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. ==============================================================================