diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-02-01 19:13:47 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-02-01 19:13:47 +0000 |
| commit | a1c68b4e6bc2ec195e7b23cbb7028dbc6b8698a2 (patch) | |
| tree | 53eb52256fef89efdc44ea9f44a63ed0e5c2f3d9 | |
| parent | 58f882d4b22193755918704971e93c2ed1e107f4 (diff) | |
| download | postgresql-a1c68b4e6bc2ec195e7b23cbb7028dbc6b8698a2.tar.gz postgresql-a1c68b4e6bc2ec195e7b23cbb7028dbc6b8698a2.zip | |
A patch for the GROUP BY/HAVING example. p.date should be s.date.
Robert B. Easter
| -rw-r--r-- | doc/src/sgml/queries.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index e9ede076411..5d22e5314ec 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v 1.1 2001/01/22 23:34:33 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v 1.2 2001/02/01 19:13:47 momjian Exp $ --> <chapter id="queries"> <title>Queries</title> @@ -531,7 +531,7 @@ SELECT pid AS "Products", p.name AS "Over 5000", (sum(s.units) * (p.price - p.cost)) AS "Past Month Profit" FROM products p LEFT JOIN sales s USING ( pid ) - WHERE p.date > CURRENT_DATE - INTERVAL '4 weeks' + WHERE s.date > CURRENT_DATE - INTERVAL '4 weeks' GROUP BY pid, p.name, p.price, p.cost HAVING p.price > 5000; </programlisting> |