From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>, "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org> |
Subject: | Re: [GENERAL] Illegal use of aggregates or non-group column in target list |
Date: | 2000-03-03 19:06:17 |
Message-ID: | 4.2.0.58.20000303150454.00bd4100@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try :
select target, avg(reaction_time) from data_table group by target;
Haven't tested it, but it should be close to what you're looking for.
At 02:14 PM 3/3/00, G. Anthony Reina wrote:
>I'd like to return an average for one item in my database grouped by
>another item. For example,
>
>The table looks like this:
>=================
>CREATE TABLE data_table (
> subject text,
> arm char,
> target int4, -- end of primary
>key
> reaction_time float4
>);
>CREATE UNIQUE INDEX pkdata_table ON data_table (subject, arm, target);
>
>
>The command I'd like to use is something like:
>================================
>select target, avg(reaction_time) from data_table;
>
>and I'd like this command to return:
>
>target | avg
>=============
> 1 | 301.3
> 2 | 311.45
> 3 | 299.1
> 4 | 300.8
>
>
>However, this statement just gives me the error: Illegal use of
>aggregates or non-group column in target list.
>
>So apparently I can only return either one or the other but not the two
>together. Is there a way to get the output I want in SQL?
>
>Thanks.
>-Tony
>
>
>
>************
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 2000-03-03 20:15:35 | Re: [GENERAL] Regular expressions syntax: is \ the escape character ? |
Previous Message | Gabriel Fernandez | 2000-03-03 19:04:50 | Regular expressions syntax: is \ the escape character ? |