CHAR LIKE VARCHAR

Поиск
Список
Период
Сортировка
Искать
От
Ilja Golshtein
Тема
CHAR LIKE VARCHAR
Дата
Msg-id
42A559B9.000001.28500@mfront7.yandex.ru
Список
Дерево обсуждения
CHAR LIKE VARCHAR "Ilja Golshtein" <ilejn@yandex.ru>
Re: CHAR LIKE VARCHAR Richard Huxton <dev@archonet.com>
Re: CHAR LIKE VARCHAR Michael Glaesemann <grzm@myrealbox.com>
Re: CHAR LIKE VARCHAR Tom Lane <tgl@sss.pgh.pa.us>
Hi!

I came across following difference
between "LIKE" and "=" regarding
CHARs and VARCHARs

create table aa(f5 char(5), fv varchar(5));
insert into aa values('str1', 'str1');
select count(*) from aa where f5 = fv;
> 1
select count(*) from aa where f5 like fv;
> 0

I understand trailing spaces in CHAR are not
significant though I expect DBMS shows
consistent (and, ideally, clearly documented)
behavior. 

From my point of view in example above 
it would be nice to have the same result 
for both queries regardless it is 0 or 1.

Of course, I may be wrong. Is there a clear 
concept behind the difference between "LIKE"
and "="?

Thanks.

-- 
Best regards
Ilja Golshtein
В списке pgsql-general по дате отправления
От: Rodríguez Rodríguez, Pere
Дата:
Сообщение: Re: return two elements
От: Himanshu Baweja
Дата:
FAQ