Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 6987D2E002C
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 10:26:35 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 54475-03-6
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 10:26:23 -0300 (ADT)
X-Greylist: delayed 00:30:00.86724 by SQLgrey-1.7.5
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by developer.postgresql.org (Postfix) with ESMTP id B449D2E004C
	for <pgsql-sql@postgresql.org>; Tue, 22 Apr 2008 10:26:16 -0300 (ADT)
Received: from DOMEXT-MTA by WEBACCESS.INDICATOR.BEwith Novell_GroupWise;
	Tue, 22 Apr 2008 14:56:12 +0200
Message-Id: <480DFC7F.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Tue, 22 Apr 2008 14:56:00 +0200
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: "Nacef LABIDI" <nacef.l@gmail.com>,
	"Craig Ringer" <craig@postnewspapers.com.au>
Cc: <pgsql-sql@postgresql.org>,
	"Roland Voegtli" <voegtli@scnat.ch>
Subject: Re: After updating dataset the record goes to the end of thedataset
References: <f16f7ea00804220254i671e446au7c50dca45dea10d7@mail.gmail.com>	<3
	B256469-4A00-44C3-8EB8-F49FA9F7259A@scnat.ch><f16f7ea00804220310m26753072me
	c98ef0bc6bb2c9e@mail.gmail.com><f16f7ea00804220310m26753072mec98ef0bc6bb2c9
	e@mail.gmail.com><480DDE26.50405@postnewspapers.com.au>
In-Reply-To: <480DDE26.50405@postnewspapers.com.au>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__PartBD94F570.1__="
X-imss-version: 2.050
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/140
X-Sequence-Number: 30679

--=__PartBD94F570.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Probably what you mean is that you want the order in which the records =
were=20
originally inserted into the database. In that case add a serial to your =
table and
fetch the records like
SELECT * FROM tbl WHERE 1=3D1 ORDER BY [myserialfield]
It's not foolproof but will in many cases come close to what you seem to =
be trying=20
to achieve by not using 'order by'.

Nacef LABIDI wrote:
> Yes I don't issue any sort statement, and I indeed want the data to be =
show
> as it is stored in the database.

--=__PartBD94F570.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Probably what you mean is that you want&nbsp;the order in which the =
records were </DIV>
<DIV>originally inserted into the database. In that case add a serial to =
your table and</DIV>
<DIV>fetch the records like</DIV>
<DIV>SELECT * FROM tbl WHERE 1=3D1 ORDER BY [myserialfield]</DIV>
<DIV>It's not foolproof but will in many cases&nbsp;come close to&nbsp;what=
 you seem to be trying </DIV>
<DIV>to achieve by not using 'order by'.<BR><BR>Nacef LABIDI wrote:<BR>&gt;=
 Yes I don't issue any sort statement, and I indeed want the data to be =
show<BR>&gt; as it is stored in the database.<BR></DIV></BODY></HTML>

--=__PartBD94F570.1__=--