X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id AB33F925596 for ; Thu, 22 May 2003 02:05:15 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 58406-08 for ; Thu, 22 May 2003 02:04:29 -0400 (EDT) Received: from rediffmail.com (unknown [203.199.83.39]) by developer.postgresql.org (Postfix) with SMTP id 498AB9253FD for ; Wed, 21 May 2003 23:01:06 -0400 (EDT) Received: (qmail 27002 invoked by uid 510); 22 May 2003 03:01:02 -0000 Date: 22 May 2003 03:01:02 -0000 Message-ID: <20030522030102.27001.qmail@webmail29.rediffmail.com> Received: from unknown (192.51.44.11) by rediffmail.com via HTTP; 22 may 2003 03:01:02 -0000 MIME-Version: 1.0 From: "Prashanth - Kamath" Reply-To: "Prashanth - Kamath" To: pgsql-sql@postgresql.org Subject: MIN function problem with Postgres7.3 Content-type: text/plain; format=flowed Content-Disposition: inline X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/424 X-Sequence-Number: 13589 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