lower() broken?

Vince Vielhaber <vev@michvhf.com>

From: Vince Vielhaber <vev@michvhf.com>
To: hackers@postgreSQL.org
Date: 1999-02-19T18:31:51Z
Lists: 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
==========================================================================