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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Support for Limit in Update, Insert...
Дата
Msg-id 20050909023738.GD17696@surnet.cl
обсуждение исходный текст
Ответ на Re: Support for Limit in Update, Insert...  ("Cristian Prieto" <cristian@clickdiario.com>)
Ответы Re: Support for Limit in Update, Insert...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Philip Hallstrom
Дата:
Сообщение: Re: Formatting TimeStamp
Следующее
От: Leonid Safronie
Дата:
Сообщение: Cost based SELECT/UPDATE