On Mon, May 17, 2010 at 7:28 AM, A. Kretschmer <andreas.kretsch...@schollglas.com> wrote: > 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: ...
delete from foo using (values (1),(2) ) as bla where foo.c1=bla.column1; ... Aha! Cool. That's not quite what I envisioned when you said virtual table, but it surely clarifies things. Thanks! -- Jon -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
