Using results from INSERT ... RETURNING

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: PostgreSQL hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Using results from INSERT ... RETURNING
Date: 2009-07-07 20:31:54
Message-ID: 4A53B0BA.6040104@cs.helsinki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello.

Here's a patch(WIP) that implements INSERT .. RETURNING inside a CTE.
Should apply cleanly against CVS head.

The INSERT query isn't rewritten so rules and default values don't work.
Recursive CTEs don't work either.

Regards,
Marko Tiikkaja

Attachment Content-Type Size
cte6.patch text/x-patch 28.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sergey Burladyan 2009-07-07 21:14:49 Re: 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )
Previous Message David E. Wheeler 2009-07-07 20:14:26 Re: Maintenance Policy?