Home > mailing lists

- Mailing list pgsql-sql

From	sun yu
Subject
Date	November 19, 2002 11:17:55
Msg-id	007e01c28fa3$0bc02c20$a41da8c0@192.168.29.33 Whole thread Raw
List	pgsql-sql

Tree view

HI,What can I do to solve this error;

I have two tables, as below

tabel: works

empnum | pnum | hours
--------+------+-------
E1     | P1   |    40
E1     | P2   |    20
E1     | P3   |    80
E1     | P4   |    20
E1     | P5   |    12
E1     | P6   |    12
E2     | P1   |    40
E2     | P2   |    80
E3     | P2   |    20
E4     | P2   |    20
E4     | P4   |    40
E4     | P5   |    80
(12 rows)

table:proj

I want to do this query,but system returns "ERROR:Aggregates not allowd in WHERE clause"

please help me,do the query:

   SELECT PNUM, SUM(HOURS) FROM WORKS
          GROUP BY PNUM
         HAVING EXISTS (SELECT PNAME FROM PROJ
                        WHERE PROJ.PNUM = WORKS.PNUM AND
                               SUM(WORKS.HOURS) > PROJ.BUDGET / 200);

I think this query should return two tuples:

p1/80

p5/92

☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆
孙雨
沈阳东软中间件技术公司数据管理事业部
E-mail: sun.yu@neusoft.com
☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆

pgsql-sql by date:

From: Evgen Potemkin
Date: 19 November 2002, 11:17:54
Subject: Re: Proposal of hierarchical queries, a la Oracle

From: Evgen Potemkin
Date: 19 November 2002, 11:18:02
Subject: Re: Proposal of hierarchical queries, a la Oracle

- Mailing list pgsql-sql

Previous

Next