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

From Alvaro Herrera
Subject Re: Support for Limit in Update, Insert...
Date
Msg-id 20050909023738.GD17696@surnet.cl
Whole thread Raw
In response to Re: Support for Limit in Update, Insert...  ("Cristian Prieto" <cristian@clickdiario.com>)
Responses Re: Support for Limit in Update, Insert...
List pgsql-general
On Thu, Sep 08, 2005 at 07:19:34PM -0600, Cristian Prieto wrote:
> Maybe the first 1000 rows based in the primary index????

No, this is not a satisfactory answer, because 1. it's possible that
there's no primary key at all, or 2. said index may not get used for the
execution of the update.  Maybe something else I'm forgetting right now.

This has been discussed before, and rejected.  Please see the archives.

--
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Java is clearly an example of a money oriented programming"  (A. Stepanov)

pgsql-general by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: Formatting TimeStamp
Next
From: Leonid Safronie
Date:
Subject: Cost based SELECT/UPDATE