Commita1c68b4

committed

A patch for the GROUP BY/HAVING example. p.date should be s.date.

Robert B. Easter

1 parent58f882d commita1c68b4Copy full SHA for a1c68b4

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v 1.1 2001/01/22 23:34:33 petere Exp $ -->`
	`1`	`+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v 1.2 2001/02/01 19:13:47 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="queries">`
`4`	`4`	`<title>Queries</title>`
`@@ -531,7 +531,7 @@ SELECT pid AS "Products",`
`531`	`531`	`p.name AS "Over 5000",`
`532`	`532`	`(sum(s.units) * (p.price - p.cost)) AS "Past Month Profit"`
`533`	`533`	`FROM products p LEFT JOIN sales s USING ( pid )`
`534`		`- WHEREp.date > CURRENT_DATE - INTERVAL '4 weeks'`
	`534`	`+ WHEREs.date > CURRENT_DATE - INTERVAL '4 weeks'`
`535`	`535`	`GROUP BY pid, p.name, p.price, p.cost`
`536`	`536`	`HAVING p.price > 5000;`
`537`	`537`	`</programlisting>`

Comments

(0)