2010/5/17 Віталій Тимчишин <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 This syntax I'm familiar with. The author of the previous message (Pierre C) indicated that there is a concept of a virtual table which could be joined to. I'd like to know what this virtual table thing is, specifically in the context of joins. -- Jon -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
