[jboss-user] [JBoss Seam] - Re: PostgreSQL collection problem

askesis do-not-reply at jboss.com
Fri Dec 8 03:19:47 EST 2006


Nothing wrong with this: unless you specify an order in an SQL query, a
database is allowed to return the result set in any order it likes. It
is not even required to return the same result set in the same order if
the query is rerun immediately after the first time.


The fact that MySQL returns the records in insertion order is a
"coincidence".

-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3992176#3992176

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3992176



More information about the jboss-user mailing list