Re: Bug in LIKE operator processing - Mailing list pgsql-bugs

On Mon, 27 Jan 2003, [iso-8859-2] =AFak, S=B3awomir wrote:

> I've found that statement:
>
>     SELECT * FROM os WHERE 'FreeBSD 4.7-RC'
>         LIKE string_id; (one of string_id's is 'FreeBSD 4.7%')

>  string_id | character(32)         |

character(32) has space padding which is probably getting in your way.
I'd suggest moving to varchar(32).