| From: | Erik Behrends <erik(dot)behrends(at)inxnet(dot)de> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Problems with "order by clause" |
| Date: | 2002-04-26 12:12:10 |
| Message-ID: | 3CC9441A.2030906@inxnet.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hello to everybody,
I have a little problem concerning the "ORDER BY" clause.
Consider a table "test" having one text field "val" with the following
entries:
tralala
Tralala
tralal
Now, I want to execute the following query via JDBC:
SELECT * FROM test ORDER BY val DESC;
When using JDBC with Oracle or Sapdb I get the following result:
tralala
tralal
Tralala
(correct lexicographic order as expected by Java)
Now, using PostgreSQL (7.1.3 with JDBC driver 7.2) the result is:
Tralala
tralala
tralal
(lexicographic order as implemented in PostgreSQL)
Any ideas what's going on there?
Thanks in advance,
-- Erik Behrends
----------------------------------------------
Inxnet GmbH
intelligent software solutions
tel. 0761 / 296 979-0
http://www.inxnet.de
----------------------------------------------
P.S.: Versenden personalisierter E-Mails - mit
inxmail ein Kinderspiel! http://www.inxmail.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2002-04-26 15:48:34 | Re: Problems with "order by clause" |
| Previous Message | Joseph Shraibman | 2002-04-25 20:25:48 | NullPointerException with 7.2.1 ResultSet |