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

From Tom Lane
Subject Re: Support for Limit in Update, Insert...
Date
Msg-id 26926.1126224359@sss.pgh.pa.us
Whole thread Raw
In response to Support for Limit in Update, Insert...  ("Cristian Prieto" <cristian@clickdiario.com>)
List pgsql-general
"Cristian Prieto" <cristian@clickdiario.com> writes:
> Would be any future support for limit in update/insert queries? so you =
> could do something like
> update table1 set col1=3Dvalue1 limit 1000;
> would update just the first 1000 rows in the table.

That seems like a spectacularly bad idea, considering that you could
have no guarantees about *which* 1000 rows get updated.

            regards, tom lane

pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: Re: back references using regex
Next
From: "Cristian Prieto"
Date:
Subject: Re: Support for Limit in Update, Insert...