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: | Raw Message | Whole Thread | 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 |