Re: Stalled post to pgsql-bugs - Mailing list pgsql-general

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.craciun@gmail.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@postgresql.org <pgsql-bugs-owner@postgresql.org>
> Date: Sep 3, 2007 8:13 PM
> Subject: Stalled post to pgsql-bugs
> To: Ciprian Dorin Craciun <ciprian.craciun@gmail.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.craciun@gmail.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@postgresql.org
>
>
> ---------- Forwarded message ----------
> From: "Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>
> To: pgsql-bugs@postgresql.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.craciun@gmail.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/
>