Re: How do I use returning in a view? - Mailing list pgsql-general

From Tom Lane
Subject Re: How do I use returning in a view?
Date
Msg-id 20424.1171735572@sss.pgh.pa.us
Whole thread Raw
In response to How do I use returning in a view?  ("Karen Hill" <karen_hill22@yahoo.com>)
List pgsql-general
"Karen Hill" <karen_hill22@yahoo.com> writes:
> I have an updateable view (using rules) that I'm trying to improve by
> using 8.2's RETURNING feature to place the result of one insert into
> the next.

That's not what it's for.  RETURNING in an insert rule is to define what
to return if someone does an INSERT/RETURNING *on the view*.  It's
thrown away if the rule is invoked by a plain INSERT.

            regards, tom lane

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: user input during runtime
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Addons