MIN function problem with Postgres7.3 - Mailing list pgsql-sql

From Prashanth - Kamath
Subject MIN function problem with Postgres7.3
Date
Msg-id 20030522030102.27001.qmail@webmail29.rediffmail.com
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: David W Noon
Date:
Subject: Re: Performance on temp table inserts
Next
From: "John Dwyer"
Date:
Subject: What do you think of this?