Re: sequence chages after firing update - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: sequence chages after firing update
Date
Msg-id 20020626074448.M91099-100000@megazone23.bigpanda.com
Whole thread Raw
In response to sequence chages after firing update  (Subhashini Karthikeyan <subhaksekar@yahoo.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance Ideas
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Efficient Query For Mapping IP Addresses To Country Code.