Re: Stalled post to pgsql-bugs

Hello

it's feature :(. And it isn't supported in 8.3 too

all info about unsupported features you can find in ToDo list
http://www.postgresql.org/docs/faqs.TODO.html

# Allow SQL-language functions to return results from RETURNING queries

http://archives.postgresql.org/pgsql-hackers/2006-10/msg00665.php
# Allow SQL-language functions to reference parameters by parameter name

Currently SQL-language functions can only refer to dollar parameters, e.g. $1

Regards
Pavel Stehule

2007/10/19, Ciprian Dorin Craciun <ciprian(dot)craciun(at)gmail(dot)com>:
> Hello all!
>
> Almost two months ago I have posted a bug on the bug reporting
> form that is available on the web page... (I forward here the email I
> got in response.) It was related about the RETURNING feature available
> for INSERT, UPDATE and DELETE, and the fact that I can not use it as
> last statement is PL/SQL functions.
>
> But until now I saw no activity on this bug... How can I track it?
> Has some one looked at it? Is it already fixed?
>
> I've monitored the release notes of every release from 8.2.5 and
> saw nothing related to the issue.
>
> Could some one point me into the right direction? Or I could try
> to fix it my self if someone could tell me where to start...
>
> Thank you all,
> Ciprian.
>
> P.S.: I have also tried to send this same message directly to
> psql-bugs mailing list but obtained the same message that the report
> is stalled.
>
>
> ---------- Forwarded message ----------
> From: pgsql-bugs-owner(at)postgresql(dot)org <pgsql-bugs-owner(at)postgresql(dot)org>
> Date: Sep 3, 2007 8:13 PM
> Subject: Stalled post to pgsql-bugs
> To: Ciprian Dorin Craciun <ciprian(dot)craciun(at)gmail(dot)com>
>
>
> Your message to pgsql-bugs has been delayed, and requires the approval
> of the moderators, for the following reason(s):
>
> The author ("Ciprian Dorin Craciun" <ciprian(dot)craciun(at)gmail(dot)com>)
> is not a member of any of the restrict_post groups.
>
> If you do not wish the message to be posted, or have other concerns,
> please send a message to the list owners at the following address:
> pgsql-bugs-owner(at)postgresql(dot)org
>
>
> ---------- Forwarded message ----------
> From: "Ciprian Dorin Craciun" <ciprian(dot)craciun(at)gmail(dot)com>
> To: pgsql-bugs(at)postgresql(dot)org
> Date: Mon, 3 Sep 2007 17:13:40 GMT
> Subject: BUG #3596: "insert ... returning *" not usable as last
> statement in a function...
>
> The following bug has been logged online:
>
> Bug reference: 3596
> Logged by: Ciprian Dorin Craciun
> Email address: ciprian(dot)craciun(at)gmail(dot)com
> PostgreSQL version: 8.2.4
> Operating system: Debian Etch (4.0)
> Description: "insert ... returning *" not usable as last statement in
> a function...
> Details:
>
> I think the best explanation is the example just above...
>
> The idea is that in 8.2 insert statement was modified by adding an returning
> option, that modifies insert to behave also as a select statement by
> returning all the rows inserted. But unfortunately this option can not be
> used inside functions that return something as a last statement...
>
> create table table1 ( field int );
>
> create function function1 ( int ) returns table1 as $$
> insert into table1 values ($1) returning *;
> $$ language sql;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>