| From: | "Prashanth - Kamath" <prashanth_kamath1(at)rediffmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | MIN function problem with Postgres7.3 |
| Date: | 2003-05-22 03:01:02 |
| Message-ID: | 20030522030102.27001.qmail@webmail29.rediffmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luis Sousa | 2003-05-22 09:10:15 | Re: Can arrays reference primary keys in CREATE TABLE? |
| Previous Message | Tom Lane | 2003-05-22 02:45:44 | Re: function prepared plan |