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: | Raw Message | Whole Thread | 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 |