Maybe the first 1000 rows based in the primary index????
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, September 08, 2005 6:05 PM
Subject: Re: [GENERAL] Support for Limit in Update, Insert...
"Cristian Prieto" <[EMAIL PROTECTED]> 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
