Re: ORDER BY random() LIMIT 1 slowness

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: ORDER BY random() LIMIT 1 slowness
Дата
Msg-id Pine.LNX.4.33.0212181258290.3807-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: ORDER BY random() LIMIT 1 slowness  (Jean-Luc Lachance <jllachan@nsd.ca>)
Список pgsql-general
On Wed, 18 Dec 2002, Jean-Luc Lachance wrote:

> Alvara,
>
> But instead of returning an error, currval() should return last_value if
> nextval() was not called (with all the caveat of couse).  I think it
> would be more usefull that way.

no, that would be like walking around with a gun pointed at your foot, to
quote Tom Lane.

See my post on transactions and such. Remember that everything in
Postgresql is designed to make transactions safe.  currval working without
a nextval or setval before it is dangerous in the exterme to transactions.


В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Measuring CPU time use? (Another stupid question)
Следующее
От: Jessica Blank
Дата:
Сообщение: Re: Measuring CPU time use? (Another stupid question)