Support for Limit in Update, Insert... - Mailing list pgsql-general

From Cristian Prieto
Subject Support for Limit in Update, Insert...
Date
Msg-id 03e501c5b4cd$f546cb40$6500a8c0@gt.ClickDiario.local
Whole thread Raw
Responses Re: Support for Limit in Update, Insert...
List pgsql-general
Would be any future support for limit in update/insert queries? so you could do something like
 
update table1 set col1=value1 limit 1000;
 
would update just the first 1000 rows in the table. I've been playing a little with the SPI and I get the SPI already has the support for limit the number of changes or elements in a query (the SPI_execute function).
 
Any comments?
 
Thanks a lot

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: back references using regex
Next
From: Matthew Peter
Date:
Subject: Re: back references using regex