2010/5/17 Jon Nelson <jnelson+pg...@jamponi.net<jnelson%2bpg...@jamponi.net> >
> 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? > > > 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
