From: | jeam(at)themail(dot)com |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Inverted result set, why? |
Date: | 2000-06-27 11:30:39 |
Message-ID: | 200006271130.GAA01884@eperke.themail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Piatkus | 2000-06-27 16:17:44 | ODBC (windows) and ALTER USER |
Previous Message | Michel Claes | 2000-06-27 11:28:57 | Odbc postgresql database is readonly |