Re: LIMIT for UPDATE and DELETE
| От | Etsuro Fujita | 
|---|---|
| Тема | Re: LIMIT for UPDATE and DELETE | 
| Дата | |
| Msg-id | 5417EF55.7020702@lab.ntt.co.jp обсуждение исходный текст  | 
		
| Ответ на | LIMIT for UPDATE and DELETE (Rukh Meski <rukh.meski@gmail.com>) | 
| Ответы | 
                	
            		Re: LIMIT for UPDATE and DELETE
            		
            		 | 
		
| Список | pgsql-hackers | 
(2014/08/15 6:18), Rukh Meski wrote: > Based on the feedback on my previous patch, I've separated only the > LIMIT part into its own feature. This version plays nicely with > inheritance. The intended use is splitting up big UPDATEs and DELETEs > into batches more easily and efficiently. IIUC, the patch doesn't support OFFSET with UPDATE/DELETE ... LIMIT. Is that OK? When we support ORDER BY ... LIMIT/OFFSET, we will also be allowing for OFFSET with UPDATE/DELETE ... LIMIT. So, ISTM it would be better for the patch to support OFFSET at this point. No? Thanks, Best regards, Etsuro Fujita
В списке pgsql-hackers по дате отправления: