Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199409160527.WAA28191@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: jsoi@gis.joensuu.fi (Janne Soimasuo)
Message-Id: <9409160534.AA05338@gis.joensuu.fi.noname>
Subject: Re: Group By
To: postgres@postgres.Berkeley.EDU
Date: Fri, 16 Sep 94 8:34:48 EET DST
Cc: wpp@marie.physik.tu-berlin.de
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 15 Sep 94 22:27:12 -0700
Resent-XMts: smtp

Kai asked to test a command with non linux postgres.

Here is the same query with sunOS and postgres4.2.
In postquel there is allowed only one item in the query when you use
aggregate functions. I think this is pity, because I would need it and
group by facility many times.

* retrieve ( average = int2ave{parts.Qty}, parts.supplier ) sort by  
supplier \g

Query sent to backend is "retrieve ( average = int2ave{parts.Qty}, 
parts.supplier ) sort by   supplier "
FATAL: no response from backend: detected in dump_data

Go 
*  retrieve ( average = int2ave{parts.Qty} )\g

Query sent to backend is "retrieve ( average = int2ave{parts.Qty} )"
---------------
| average     |
---------------
| 49          |
---------------


********************************************************************************
* Janne Soimasuo            *     phone +358-73-151 4519                       *
* GIS & RS lab.             *     fax   +358-73-151 3590                       *
* Faculty of Forestry       *                                                  *
* University of Joensuu     *     email janne.soimasuo@joensuu.fi              *
*                           *           jsoi@gis.joensuu.fi                    *
* P.O.BOX 111               *                                                  *
* FIN-80101 JOENSUU         * "There never enough time to do all the nothing   *
* FINLAND                   *  you want"  Calvin                               *
********************************************************************************

==============================================================================
   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.
==============================================================================