Change in behaviour of ORDER BY clause in PG7.3

Поиск
Список
Период
Сортировка
От Ollie Clark
Тема Change in behaviour of ORDER BY clause in PG7.3
Дата
Msg-id slrnbrpa7l.8m0.oliverc@cslin-gps.csunix.comp.leeds.ac.uk
обсуждение исходный текст
Ответы Re: Change in behaviour of ORDER BY clause in PG7.3
Список pgsql-hackers
Since upgrading to 7.3 I've noticed that the ORDER BY clause seems to 
ignore leading spaces/punctuation for eg we have a simple table with 6 
rows containing:

'a'
'b'
'c'
'd'
' bill'
'-bill'

SELECT * FROM table ORDER BY 1;

gives:

a
bbill
-bill
c
d

which is different from previous versions and different to MySQL and SQL 
Server. Is this a bug, or can you turn this behaviour off? It's breaking a 
lot of our applications!

-- 
Ollie Clark    -    oliverc@comp.leeds.ac.uk    -    ol@ollieclark.com
http://www.ollieclark.com/acronyms.html



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

Предыдущее
От: "Yurgis Baykshtis"
Дата:
Сообщение: Re: PANIC: rename from /data/pg_xlog/0000002200000009
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: $Id$ -> $PostgreSQL$ Change