Commitf19f0ee

committed

Fix broken example in PL/pgSQL document.

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

1 parent7b1c2a0 commitf19f0eeCopy full SHA for f19f0ee

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

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

Comments

(0)