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

Attachment: 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

Reply via email to