In response to Jon Nelson : > On Mon, May 17, 2010 at 5:10 AM, Pierre C <li...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
