Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 011CD4765FF for ; Wed, 26 Jun 2002 11:28:22 -0400 (EDT) Mailbox-Line: From sszabo@megazone23.bigpanda.com Wed Jun 26 11:28:22 2002 Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 110124768F3 for ; Wed, 26 Jun 2002 10:45:57 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 510C4D5F7; Wed, 26 Jun 2002 07:46:01 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 44DBC5C02; Wed, 26 Jun 2002 07:46:01 -0700 (PDT) Date: Wed, 26 Jun 2002 07:46:01 -0700 (PDT) From: Stephan Szabo To: Subhashini Karthikeyan Cc: Subject: Re: sequence chages after firing update In-Reply-To: <20020626114724.36949.qmail@web13108.mail.yahoo.com> Message-ID: <20020626074448.M91099-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-3.5 required=5.0 tests=IN_REP_TO,X_NOT_PRESENT,NO_MX_FOR_FROM version=2.30 X-Spam-Level: X-Archive-Number: 200206/350 X-Sequence-Number: 8315 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)