Well, it does indeed seem that this is not dependent on the PostgreSQL version, because I see the same incorrect behavior out of version 8.3.3.
The immediate problem is not the lack of ORDER BY; the immediate problem is that ORDER BY does not seem to work for these data. I tried the same experiment, completely unconnected with DSpace, and got the same result: "b" sorts before some "," and after others...or, more likely, the data are returned in entry order regardless of ORDER BY. I've tested both CHAR and VARCHAR and they both do this. INT columns are ordered properly. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] Typically when a software vendor says that a product is "intuitive" he means the exact opposite.
pgplKeVAPPbeU.pgp
Description: PGP signature
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
