From: | Vincent Stoessel <vincent(at)xaymaca(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | bug/feature with upper function? |
Date: | 2002-03-20 17:00:39 |
Message-ID: | 3C98C037.6080805@xaymaca.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello All,
I am having a serious problem matching text using the upper() function
in postgres 7.2 (from developer rpms) on Redhat 7.2
How to replicate:
1. create a table of one column character(20)
2.insert words with all uppercase letters.
3. Try matching the word with "select * from table where
upper(columnname) = 'word'"
I get a result of zero every time.
db=# SELECT * from upp_test ;
uname
----------------------
KAT
KAT
KAT
KAT
KAT
(5 rows)
FEC=# SELECT * from upp_test where uname = 'KAT' ;
uname
----------------------
KAT
KAT
KAT
KAT
KAT
(5 rows)
db=# SELECT * from upp_test where upper(uname) = 'KAT' ;
uname
-------
(0 rows)
The reason I am worried about this is that I have a mix of upper and
lower case words in the real world coumn and I have not been getting
complete matches. Is this a bug?
Vincent
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-03-20 17:09:16 | Re: Notify argument? |
Previous Message | Doug McNaught | 2002-03-20 16:45:49 | Re: Passing parameters to triggers |