problem with dots in order by

Поиск
Список
Период
Сортировка
От Ruben Oliveira
Тема problem with dots in order by
Дата
Msg-id 42121D9A.6060301@netcabo.pt
обсуждение исходный текст
Ответы Re: problem with dots in order by  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: problem with dots in order by  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Marco Colombo
Дата:
Сообщение: Re: Lost rows/data corruption?
Следующее
От: Jan Poslusny
Дата:
Сообщение: Re: random record from small set