agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Janne Soimasuo <jsoi@gis.joensuu.fi>
To: postgres@postgres.Berkeley.EDU
Cc: wpp@marie.physik.tu-berlin.de
Subject: Re: Group By
Date: Fri, 16 Sep 94 8:34:48 EET DST
Message-ID: <9409160534.AA05338@gis.joensuu.fi.noname> (raw)
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.
==============================================================================
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: jsoi@gis.joensuu.fi, wpp@marie.physik.tu-berlin.de
Subject: Re: Group By
In-Reply-To: <9409160534.AA05338@gis.joensuu.fi.noname>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox