From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Subject: | lower() broken? |
Date: | 1999-02-19 18:31:51 |
Message-ID: | XFMail.990219133151.vev@michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(at)michvhf(dot)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
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-19 19:28:34 | New optimizer README |
Previous Message | The Hermit Hacker | 1999-02-19 17:45:56 | Major bug, possible, with Solaris 7? |