On Sep 27, 2010, at 22:08 , Tim Uckun wrote: > update to_be_deleted set mark = true where ctid = any (array( select > ctid from to_be_deleted limit 10)); Why are you messing with ctid? Does the table have no key? If not, you should fix that first. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general