Phillip Sitbon <phillip(at)sitbon(dot)net> writes:
> I've had to do this quite a bit, and here's how I usually go about it:
> DELETE FROM data_structures_items WHERE NOT EXISTS
> (SELECT 1 FROM data_structures WHERE id_structure=id_data_structure LIMIT 1);
> Even when the item in the subquery is a primary key, I find it
> semantically informative to always use "LIMIT 1".
EXISTS implies LIMIT 1 for its subquery; there's no value for either
comprehension or performance in adding that. I'd recommend leaving
it off, because it makes your query syntax nonstandard for no benefit.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Tim||Date: 2009-06-16 01:08:46|
|Subject: Fwd: Yum Update Errors|
|Previous:||From: Phillip Sitbon||Date: 2009-06-15 18:34:40|
|Subject: Re: Delete performance|