| From: | Marko Tiikkaja <marko(at)joh(dot)to> |
|---|---|
| To: | PG Docs <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Broken example in PL/PgSQL documentation |
| Date: | 2014-09-04 12:06:40 |
| Message-ID: | 540855D0.4020108@joh.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Hi,
Just came across a broken example in the docs:
local:marko=#* select * from extended_sales(1);
ERROR: column reference "quantity" is ambiguous
LINE 1: SELECT quantity, quantity * price FROM sales
^
DETAIL: It could refer to either a PL/pgSQL variable or a table column.
QUERY: SELECT quantity, quantity * price FROM sales
WHERE itemno = p_itemno
CONTEXT: PL/pgSQL function "extended_sales" line 3 at RETURN QUERY
Patch to fix this attached.
.marko
| Attachment | Content-Type | Size |
|---|---|---|
| plpgsql_return_query.patch | text/plain | 687 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-09-04 13:22:28 | Re: Missing docs: setting up replication slots for standbys |
| Previous Message | Josh Berkus | 2014-09-04 06:06:50 | Re: Missing docs: setting up replication slots for standbys |