CHAR LIKE VARCHAR

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: CHAR LIKE VARCHAR
Date: 2005-06-07 08:24:25
Message-ID: 42A559B9.000001.28500@mfront7.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Himanshu Baweja 2005-06-07 08:44:12 Re: Logging query plan for queries
Previous Message Rodríguez Rodríguez, Pere 2005-06-07 08:08:27 Re: return two elements