Re: DELETE with LIMIT (or my first hack)

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