Re: LIKE, "=" and fixed-width character fields - Mailing list pgsql-general

Dmitry Teslenko wrote:
>> richardh=> SELECT * FROM chartbl WHERE c LIKE '111';
>>  c
>> ---
>> (0 rows)
>>
>> richardh=> SELECT * FROM chartbl WHERE c LIKE '111       ';
>>     c
>> ------------
>>  111
>> (1 row)
>>
>> richardh=> SELECT * FROM chartbl WHERE c LIKE '111%';
>>     c
>> ------------
>>  111
>> (1 row)
>>
>
> '111%' would also match '1111' and '111anything', wouldn't it?

Yes.

I'm guessing what you actually want is varchar(10) rather than char(10)
as a type.

--
  Richard Huxton
  Archonet Ltd