interesting finding on order by behaviour

Поиск
Список
Период
Сортировка
От Samuel Hwang
Тема interesting finding on order by behaviour
Дата
Msg-id 624925e3-6347-4475-b243-d1020e8a4700@p29g2000pre.googlegroups.com
обсуждение исходный текст
Ответы Re: interesting finding on order by behaviour  (Reid Thompson <Reid.Thompson@ateb.com>)
Re: interesting finding on order by behaviour  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: interesting finding on order by behaviour  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL
9.0.4 and found something interesting...

set up
=====
drop table t1
create table t1 (f1 varchar(100))
insert into t1 (f1) values ('AbC')
insert into t1 (f1) values ('CdE')
insert into t1 (f1) values ('abc')
insert into t1 (f1) values ('ABc')
insert into t1 (f1) values ('cde')

test
===
select * from t1 order by f1
select min(f1) as min, max(f1) as max from t1

results
=====
SQL Server 2008 R2 (with case insensitive data, the ordering follows
ASCII order)

f1
---
AbC
abc
ABc
cde
CdE

min    max
------   -------
AbC   CdE

Oracle 10 (data is case-sensitive, the ordering follows ASCII order)

f1
---
ABc
AbC
CdE
abc
cde

min    max
------   -------
ABc   cde

PostgreSQL 9.0.4 (data is case-sensitive, the ordering is ...
DIFFERENT)

f1
---
abc
AbC
ABc
cde
CdE

min    max
------   -------
abc     CdE

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Is there a way to 'unrestrict' drop view?
Следующее
От: Reid Thompson
Дата:
Сообщение: Re: interesting finding on order by behaviour