From: | "Ricardo Coelho" <rcoelho(at)px(dot)com(dot)br> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Non-group columns with aggregate functions |
Date: | 1999-12-22 18:56:16 |
Message-ID: | 000701bf4cae$3c8c2060$33fafdc8@px.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi All,
I had seen the answer for my question before, but hacker's E-mail search
isn't finding any word.
I'm using PgSQL 6.5.2 with RHLinux 6.0.
How can I use non-group columns in a select with aggregate functions ? To
me, the following query makes sense.
teste=> create table people(pp_id int2 primary key, pp_name text);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'people_pkey'
for table 'people'
CREATE
teste=> create table workpgsql(wp_people int2, wp_date date, hoursofwork
int2);
CREATE
teste=> insert into people values (1,'ME');
INSERT 226808 1
teste=> insert into people values (2,'YOU');
INSERT 226809 1
teste=> insert into workpgsql values (1,'01/01/2000',5);
INSERT 226810 1
teste=> insert into workpgsql values (1,'01/01/2000',4);
INSERT 226811 1
teste=> insert into workpgsql values (2,'01/01/2000',6);
INSERT 226812 1
teste=> insert into workpgsql values (2,'01/01/2000',6);
INSERT 226813 1
teste=> select pp_name,wp_date,sum(hoursofwork) from people,workpgsql
teste-> where pp_id=wp_people
teste-> group by wp_people,wp_date;
ERROR: Illegal use of aggregates or non-group column in target list
If anybody knows how to rebuild this query to work, thanks in advance.
Thanks,
Ricardo Coelho.
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 1999-12-22 20:21:21 | Re: [HACKERS] Non-group columns with aggregate functions |
Previous Message | Bruce Momjian | 1999-12-22 18:07:45 | tab size |