On 05/23/2010 02:15 AM, rihad wrote:> In this query:> UPDATE foo> SET allocated_to=?> WHERE id=(SELECT MIN(id) FROM foo WHERE allocated_to IS NULL)> AND allocated_to IS NULL> RETURNING id
Isn't the "AND allocated_to IS NULL" clause redundant?
-- Lew