the necessity of allowing limit and order by clause to be used with delete and update statement is discussed in the past and added to the todo list
preveouse mailing list descissions http://archives.postgresql.org/pgadmin-hackers/2010-04/msg00078.php http://archives.postgresql.org/pgsql-hackers/2010-11/msg01997.php i attached a small patch for its implementation. Notice : inorder to avoid unpredictable result the patch did not allow limit clause without order by and vise versal. comment please? Regareds Surafel
delete_update_with_limit_orderby_v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
