On 2010-12-01 1:46 PM, Valentine Gogichashvili wrote:
> And speaking about pushing
> data from one table to another, what I really would like to be able to do
> would be also something like:
>
> INSERT INTO ...
> DELETE FROM ... WHERE... ORDER BY.. [LIMIT...]
> RETURNING...;
>
> this would be also quite efficient when re-arranging data in table
> partitions
There already are plans for implementing this (and actually a patch in
the latest commitfest, look for "writeable CTEs"), sans the ORDER BY and
LIMIT part.
Regards,
Marko Tiikkaja