Skip site navigation (1) Skip section navigation (2)

Re: DELETE with LIMIT (or my first hack)

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: Valentine Gogichashvili <valgog(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Csaba Nagy <ncslists(at)googlemail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Daniel Loureiro <loureirorg(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: DELETE with LIMIT (or my first hack)
Date: 2010-12-01 13:11:25
Message-ID: 4CF6497D.3040303@cs.helsinki.fi (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2010-12-01 13:39:07
Subject: Re: crash-safe visibility map, take three
Previous:From: LewDate: 2010-12-01 12:27:59
Subject: Re: [HACKERS] Improved JDBC driver part 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group