On Sun, 12 Mar 2006, L.Jumadi wrote: > > The following bug has been logged online: > > Bug reference: 2314 > Logged by: L.Jumadi > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.3 > Operating system: SimplyMepis 3.4.3 with kernel 2.6.15.2 > Description: The Order changed? > Details: > > I have a table named test with field like this: > ocode varchar(8), code varchar(8) with primary key > at ocode.With data like this: > ocode code > 'test' '-0' > 'test' '-1' > 'test' '1' > 'test' '2' > I give the command in the psql like this: > SELECT * FROM test ORDER BY code; > the result is like this: > ocode code > test -0 > test 1 > test -1 > test 2 > When I use 8.0.1 version this command gives me result > like this > ocode code > test -0 > test -1 > test 1 > test 2 > The question is this a bug?or there is changes in the > way postgreSQL order the field? Thank's in advance
The most likely explanation is that the locale choice at initdb time for the two versions was different. The 8.0 result looks consistent with "C" locale and the 8.1 with some others (like en_US). For example: [EMAIL PROTECTED] test]$ cat file -0 -1 1 2 [EMAIL PROTECTED] test]$ LANG="C" sort file -0 -1 1 2 [EMAIL PROTECTED] test]$ LANG="en_US" sort file -0 1 -1 2 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
