Change in behaviour of ORDER BY clause in PG7.3

From: Ollie Clark <oliverc(at)comp(dot)leeds(dot)ac(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Change in behaviour of ORDER BY clause in PG7.3
Date: 2003-11-20 11:43:53
Message-ID: slrnbrpa7l.8m0.oliverc@cslin-gps.csunix.comp.leeds.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
b
bill
-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(at)comp(dot)leeds(dot)ac(dot)uk - ol(at)ollieclark(dot)com
http://www.ollieclark.com/acronyms.html

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2003-11-20 11:53:17 tsearch2 patch for 7.4.1
Previous Message strk 2003-11-20 10:23:09 Re: PG7.4 ordering operator