Re: delete operation with "where XXX in"

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: delete operation with "where XXX in"
Date: 2002-09-23 18:11:38
Message-ID: 000901c2632c$a9488c10$5be0d089@ekelhardt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>If you don't mind a nonstandard query you can write
>
>delete from lr_object_usage where
>lr_locked_objects.lr_object_usage_id = lr_object_usage_id
>and lr_locked_objects.timeout_time < now() ;

Wow, i have not seen a query like that.

Thanks a lot Tom! No i dont mind as long it is that fast compared to the
other ("in") way :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2002-09-23 18:14:58 Re: Postgresql Automatic vacuum
Previous Message Dan Ostrowski 2002-09-23 18:05:11 Different Port for PostgreSQL?