I'm running the following SQL commands on a new PostgreSQL 9.0 database, one on Linux, one on Windows.
create table i (j varchar(4));
insert into i (j) values ('A'), ('E'), ('<C P'), ('F');
select j from i order by j asc;
On the Windows server I get the following:
----
<C P
A
E
F
----
On the Linux server, I get this instead:
----
A
<C P
E
F
----
Can anyone tell me why the sort order would come out differently?
Thanks,
--
Doug Gorley | doug.gorley@xxxxxxxxx