On Fri, Oct 10, 2014 at 2:37 AM, Pavel Stehule wrote:
>
>
> 2014-10-08 21:25 GMT+02:00 Marti Raudsepp :
>>
>> On Thu, Sep 4, 2014 at 3:06 PM, Marko Tiikkaja wrote:
>> > Just came across a broken example in the docs
>>
>> +1. New version works. I would slightly prefer adding an alias to the
>> tab
2014-10-08 21:25 GMT+02:00 Marti Raudsepp :
> On Thu, Sep 4, 2014 at 3:06 PM, Marko Tiikkaja wrote:
> > Just came across a broken example in the docs
>
> +1. New version works. I would slightly prefer adding an alias to the
> table:
>
> RETURN QUERY SELECT s.quantity, s.quantity * s.price FRO
On Thu, Sep 4, 2014 at 3:06 PM, Marko Tiikkaja wrote:
> Just came across a broken example in the docs
+1. New version works. I would slightly prefer adding an alias to the table:
RETURN QUERY SELECT s.quantity, s.quantity * s.price FROM sales AS s
WHERE s.itemno = p_itemno;
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
