DIfferent ORDER BY behaviour in 7.4.2

[Gunasekaran Balakrishnan <guna(at)motorola(dot)com>]

Hi,
    I am seeing a different sorting behaviour for varchar columns in
Postgres 7.4.2.

postgres 7.4.2 is ignoring case for varchar columns for "ORDER BY"
commands where as 7.2.2 is not.

I am in a situation where I need to do diff from the select outputs of
two databases - one in 7.2.2 and one in 7.4.2.

So, is there any way I can force the ORDER BY to ignore case or
to not ignore case ?

The test results are as follows:

CREATE TABLE testSort (
testing varchar(32));

INSERT INTO testSort VALUES ('abc');
INSERT INTO testSort VALUES ('Abd');
INSERT INTO testSort VALUES ('aBc');
INSERT INTO testSort VALUES ('Cbaa');

select * from testSort order by testing;

In Postgres 7.2.2:
------------------
TEST=# select * from testSort order by testing;
testing
---------
Abd
Cba
aBc
abc
(4 rows)


In Postgres 7.4.2:
------------------
TEST=# select * from testSort order by testing;
testing
---------
aBc
abc
Abd
Cbaa
(4 rows)


Thanks in advance,
guna.