Commitf6bb48f

committed

Fix broken example in PL/pgSQL document.

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

1 parent037b912 commitf6bb48fCopy full SHA for f6bb48f

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

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

Comments

(0)