Thread: MIN function problem with Postgres7.3

MIN function problem with Postgres7.3

From
"Prashanth - Kamath"
Date:
Hi,
The MIN function in PostgreSQL7.3 is giving me wrong output
when my data is kanji. But in PostgreSQL7.2 i get the right
answer. Is there any patch or anything that i need to do.
For example when i run
SELECT MIN(KANJI_CHAR) FROM tbl1, where tbl1 has kanji character
gives me the output similar to Oracle in PostgreSQL7.2
But the PostgreSQL7.3 does not give me the same output.
Infact the
SELECT MIN(KANJI_CHAR) FROM tbl1 and
SELECT KANJI_CHAR FROM tbl1 order by asc
gives me different output in 7.3

Can anyone give me solution.

regards
Prashanth
___________________________________________________
Get email that means BUSINESS! me @ mycompany.com.
Just Rs.1499/year.
To start, click http://www.rediffmailpro.com