Re: sequence chages after firing update

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: sequence chages after firing update
Дата
Msg-id 20020626074448.M91099-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на sequence chages after firing update  (Subhashini Karthikeyan <subhaksekar@yahoo.com>)
Список pgsql-sql
On Wed, 26 Jun 2002, Subhashini Karthikeyan wrote:

> In postgresql 7.1.3
>
> i am updateing a row. it is a 4th record.
> after updation if i am firing a select query it is
> coming as a last record ..what shall i do to avoid
> that..
> any help appriciated

If I understand the complaint, use an order by to
force an order on the select.  You can't guarantee the
order rows are returned to you unless you do (different
plans might give you rows in different orders anyway)





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance Ideas
Следующее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: Efficient Query For Mapping IP Addresses To Country Code.