Re: Slow Bulk Delete

In response to Jon Nelson :
> On Mon, May 17, 2010 at 5:10 AM, Pierre C <lists@peufeu.com> wrote:
> > - or use a JOIN delete with a virtual VALUES table
> > - or fill a temp table with ids and use a JOIN DELETE
>
> What is a virtual VALUES table? Can you give me an example of using a
> virtual table with selects, joins, and also deletes?

Something like this:

test=# select * from foo;
 c1
----
  1
  2
  3
  4
(4 rows)

test=*# delete from foo using (values (1),(2) ) as bla where foo.c1=bla.column1;
DELETE 2
test=*# select * from foo;
 c1
----
  3
  4
(2 rows)



values (1), (2) as bla   -> returns a 'virtual table' bla with one
column column1.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99