Horton

Re: [HACKERS] lower() broken?

Vince Vielhaber <vev@michvhf.com>

View thread
From: Vince Vielhaber <vev@michvhf.com>
To: hackers@postgreSQL.org
Date: 1999-02-20T05:02:08Z
Lists: pgsql-hackers 
On 19 Feb 1999, Roland Roberts wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> 
> >>>>> "Vince" == Vince Vielhaber <vev@michvhf.com> writes:
> 
>     Vince> Oops!  Yeah, I guess lower wouldn't work so well if it was
>     Vince> a numeric field.  Anyway, username is a char(8).
> 
> It won't be equal to 'joblo', it will be equal to 'joblo   '.  You may
> want to consider using varchar(8).

Damn.  That's the one thing that never even occurred to me!

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
==========================================================================