Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] DELETE and UPDATE with LIMIT and ORDER BY - Mailing list pgsql-hackers

From Surafel Temesgen
Subject [HACKERS] DELETE and UPDATE with LIMIT and ORDER BY
Date
Msg-id CALAY4q9fcrscybax7fg_uojFwjw_Wg0UMuSrf-FvN68SeSAPAA@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] DELETE and UPDATE with LIMIT and ORDER BY  (Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>)
Re: [HACKERS] DELETE and UPDATE with LIMIT and ORDER BY  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Tree view
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
 

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

pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: [HACKERS] StandbyRecoverPreparedTransactions recovers subtranslinks incorrectly
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] OK, so culicidae is *still* broken