Hello everybody !

I have this order by :
select lalala from tablex order by field_y;
where field_y is a text column.

that returns something like :
2.1004.11
21.00.461
2.1006.21

in  PostgreSQL 7.3.2 in Linux Mandrake 9.1

but in PostgreSQL 8.0.0 in Windows XP it works as I expected ...

2.1004.11
2.1006.21
21.00.461

the two config share the same Encoding when the database was created and the client enconding is the same in the two cases :

H:\Documents and Settings\User>psql -l -U postgres
       List of databases
  Name    |  Owner   | Encoding
-----------+----------+-----------
bd2005    | postgres | SQL_ASCII


Can anybody tell me if there is something I can do in the Linux config to have the same order by result ??
Using XP is only for tests... I love my Mandrake server :P



---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to