On Sat, Mar 26, 2011 at 09:46:48AM -0400, Greg Stein wrote: > If it only needs to detect a single row, then LIMIT 1 should be in the > query.
Is there really a significant difference between LIMIT 1 and not stepping through more than one result row? I'd rather keep the queries reusable for contexts where a complete list of modified nodes is required, instead of adding COUNT() (as suggested elsewhere) or LIMIT 1.