lower() broken? - Mailing list pgsql-hackers

From Vince Vielhaber
Subject lower() broken?
Date
Msg-id XFMail.990219133151.vev@michvhf.com
Whole thread Raw
List pgsql-hackers
I have a record in table cust with the username of  joblo  and it's
already lower case.  This is from a cvsup a couple of weeks old.



classifieds=> select count(*) from cust where username = lower('joblo');
count
-----   0
(1 row)

classifieds=> select count(*) from cust where username = 'joblo';
count
-----   1
(1 row)


Doesn't seem to matter if I use lower on username, 'joblo' or both.  And
there's only the one record in the table.

Did something break or did I forget how to use lower()?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null      # include <std/disclaimers.h>
       TEAM-OS2       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================




pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Major bug, possible, with Solaris 7?
Next
From: Ron Snyder
Date:
Subject: Re: [HACKERS] large objects failing (hpux10.20 sparc/solaris 2.6, gcc 2.8.1)