Re: Slow Bulk Delete

[Віталій Тимчишин <tivv00@xxxxxxxxx>]

2010/5/17 Jon Nelson <jnelson+pgsql@xxxxxxxxxxx>

On Mon, May 17, 2010 at 5:10 AM, Pierre C <lists@xxxxxxxxxx> 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