Re: delete operation with "where XXX in" - Mailing list pgsql-general

From Peter Alberer
Subject Re: delete operation with "where XXX in"
Date
Msg-id 000901c2632c$a9488c10$5be0d089@ekelhardt
Whole thread Raw
In response to Re: delete operation with "where XXX in"  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 :)



pgsql-general by date:

Previous
From: Christoph Dalitz
Date:
Subject: Re: Postgresql Automatic vacuum
Next
From: Justin Clift
Date:
Subject: Re: Different Port for PostgreSQL?