Maybe the first 1000 rows based in the primary index????
----- Original Message -----
From: "Tom Lane" <tgl@xxxxxxxxxxxxx>
To: "Cristian Prieto" <cristian@xxxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, September 08, 2005 6:05 PM
Subject: Re: Support for Limit in Update, Insert...
"Cristian Prieto" <cristian@xxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
