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

Żak, Sławomir <SZak@era.pl> writes:
> 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%')
> doesn't work. No error is reported. It does work in Oracle,

It'd probably work in Postgres too, if you'd used varchar(n) rather than
char(n) for string_id.  As is, the trailing spaces in string_id are
considered significant.
        regards, tom lane