Broken example in PL/PgSQL documentation

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

Responses

Browse pgsql-docs by date

  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