Re: sequence chages after firing update

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Subhashini Karthikeyan <subhaksekar(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: sequence chages after firing update
Date: 2002-06-26 14:46:01
Message-ID: 20020626074448.M91099-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-06-26 15:00:23 Efficient Query For Mapping IP Addresses To Country Code.
Previous Message Tom Lane 2002-06-26 14:13:56 Re: Performance Ideas