When I was on version 7.3.15 of postgres I tested the order by just as I described in my original email, and it gave me the undesired results.
There must be some sort of setting to make this work. I have seen sites where it works just fine. -Jose -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kasthuri, Sriram Sent: Wednesday, August 06, 2008 9:30 AM To: Mark H. Wood; dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Author sorting We are using postgresql v 7.3 and it worked fine with ORDER BY text_value. But not sure whether anything got changed in the later versions of postgre? - Sri -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark H. Wood Sent: 06 August 2008 14:26 To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Author sorting 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. ------------------------------------------------------------------------ - 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 ------------------------------------------------------------------------- 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