diff options
| author | Fujii Masao | 2014-10-09 18:18:01 +0000 |
|---|---|---|
| committer | Fujii Masao | 2014-10-09 18:18:01 +0000 |
| commit | f19f0ee7160e9aa0bec69146a02e544b9030191b (patch) | |
| tree | cacdbecff3bc65dd29030b3c624ee55afa0f2854 | |
| parent | 7b1c2a0f2066672b24f6257ec9b8d78a1754f494 (diff) | |
Fix broken example in PL/pgSQL document.
Back-patch to all supported branches.
Marti Raudsepp, per a report from Marko Tiikkaja
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index f008e937ee..f195495520 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -487,8 +487,8 @@ $$ LANGUAGE plpgsql; CREATE FUNCTION extended_sales(p_itemno int) RETURNS TABLE(quantity int, total numeric) AS $$ BEGIN - RETURN QUERY SELECT quantity, quantity * price FROM sales - WHERE itemno = p_itemno; + RETURN QUERY SELECT s.quantity, s.quantity * s.price FROM sales AS s + WHERE s.itemno = p_itemno; END; $$ LANGUAGE plpgsql; </programlisting> |