Commit0fbb172

committed

Fix broken example in PL/pgSQL document.

Back-patch to all supported branches.Marti Raudsepp, per a report from Marko Tiikkaja

1 parentd9a1e9d commit0fbb172Copy full SHA for 0fbb172

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -484,8 +484,8 @@ $$ LANGUAGE plpgsql;`
`484`	`484`	`CREATE FUNCTION extended_sales(p_itemno int)`
`485`	`485`	`RETURNS TABLE(quantity int, total numeric) AS $$`
`486`	`486`	`BEGIN`
`487`		`- RETURN QUERY SELECT quantity, quantity * price FROM sales`
`488`		`- WHERE itemno = p_itemno;`
	`487`	`+ RETURN QUERY SELECTs.quantity,s.quantity *s.price FROM sales AS s`
	`488`	`+ WHEREs.itemno = p_itemno;`
`489`	`489`	`END;`
`490`	`490`	`$$ LANGUAGE plpgsql;`
`491`	`491`	`</programlisting>`

Comments

(0)