2010/5/17 Jon Nelson <[email protected]<jnelson%[email protected]> >
> On Mon, May 17, 2010 at 5:10 AM, Pierre C <[email protected]> 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? > > > delete from a using (values (1),(2),(5),(8)) b(x) where a.id=b.x See http://www.postgresql.org/docs/8.4/static/sql-values.html -- Best regards, Vitalii Tymchyshyn
