Re: Support for Limit in Update, Insert...

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Cristian Prieto <cristian(at)clickdiario(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Support for Limit in Update, Insert...
Date: 2005-09-09 02:37:38
Message-ID: 20050909023738.GD17696@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonid Safronie 2005-09-09 02:46:38 Cost based SELECT/UPDATE
Previous Message Tom Lane 2005-09-09 02:32:45 Re: [GENERAL] 8.1beta timezone question