Re: [HACKERS] lower() broken?

Поиск
Список
Период
Сортировка
От Vince Vielhaber
Тема Re: [HACKERS] lower() broken?
Дата
Msg-id Pine.BSF.4.05.9902200000340.18893-100000@paprika.michvhf.com
обсуждение исходный текст
Ответ на Re: [HACKERS] lower() broken?  (Roland Roberts <roberts@panix.com>)
Список 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
==========================================================================





В списке pgsql-hackers по дате отправления:

Предыдущее
От: "D'Arcy" "J.M." Cain
Дата:
Сообщение: Re: [SQL] SQL-Query 2 get primary key
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] lower() broken?