Date: Tue, 27 Jun 2000 06:30:39 -0500 (EST)
From: jeam@themail.com
Message-Id: <200006271130.GAA01884@eperke.themail.com>
Received-From: mail.TheMail.com
To: pgsql-interfaces@postgresql.org
Cc: 
Subject: Inverted result set, why?
Authorized-User: jeam@TheMail.com
IP-Address: 216.251.69.241
Reply-To: jeam@themail.com
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="___TheMail_15_Boundary___"


--___TheMail_15_Boundary___
Content-type: text/plain


Hi there,

Using the psql utility I insert three records into a 6.5.3 postgresql table with or without indexes. I SELECT * and the records are retrieved in the order I inserted them, and that's correct.

However, if I SELECT the records from a Delphi 5 application, using the BDE and the latest ODBC driver, the result set is inverted, i.e., on the same index key, the last record I inserted is listed first and so on.

This forces me to use an index even for tables I don't need one. Or worse yet, I need to create a second, auxiliary field on the table and add it to the index when I have one in order to get the proper order of the inserted records.

I don't know if I should blame Borland's BDE or the ODBC driver.

Any clues about this problem?

Thanks in advance,

Jorge. 
__________________________________________________________________
Make A Buck Or Two @ TheMail.com - Free Internet Email
Sign-up today at http://www.themail.com/ref.htm?ref=908313 


--___TheMail_15_Boundary___--