Thanks! I thought that my bug was ignored...
It would be nice to have RETURNING used in PL/SQL functions...
Without named parameters I can live -- they are just syntactic sugar
-- but RETURNING can not be worked around...
Ciprian.
On 10/19/07, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
> 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@xxxxxxxxx>:
> > 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@xxxxxxxxxxxxxx <pgsql-bugs-owner@xxxxxxxxxxxxxx>
> > Date: Sep 3, 2007 8:13 PM
> > Subject: Stalled post to pgsql-bugs
> > To: Ciprian Dorin Craciun <ciprian.craciun@xxxxxxxxx>
> >
> >
> > 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@xxxxxxxxx>)
> > 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@xxxxxxxxxxxxxx
> >
> >
> > ---------- Forwarded message ----------
> > From: "Ciprian Dorin Craciun" <ciprian.craciun@xxxxxxxxx>
> > To: pgsql-bugs@xxxxxxxxxxxxxx
> > 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@xxxxxxxxx
> > 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/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
