2010/5/17 Jon Nelson <jnelson+pgsql(at)jamponi(dot)net<jnelson%2Bpgsql(at)jamponi(dot)net>
>
> On Mon, May 17, 2010 at 5:10 AM, Pierre C <lists(at)peufeu(dot)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