From: | Yuva Chandolu <ychandolu(at)ebates(dot)com> |
---|---|
To: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Problem with lower() function |
Date: | 2002-08-09 22:40:52 |
Message-ID: | A0F24737FCB34F489EC955D143BDD8510173E12D@exchange-sf1.corp.ebates.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi, We have a problem with lower() function working differently for two
different data types
table: yuva_test
column_name data_type
yt_name1 varchar(255)
yt_name2 char(1)
The data is
yt_name1 yt_name2
yuva F
bharat F
1234556 F
234 F
etc.
When we run the query "select * from yuva_test
lower(yt_name1)=lower('1234556') and lower(yt_name2)=lower('F')" it takes
forever to return, but if try "select * from yuva_test yt_name1='1234556'
and lower(yt_name2)=lower('F')" it returns immediately.
What is happenning here? Why lower behaving differently for varchar(255) and
char(1), and how to make first query to work without changing schema.
Thanks
Yuva
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-08-09 22:41:33 | Re: Wanted: RelationIsVisible interface |
Previous Message | Greg Sabino Mullane | 2002-08-09 22:40:34 | Wanted: RelationIsVisible interface |