Thread: BUG #6458: LIKE different to =

The following bug has been logged on the website:

Bug reference:      6458
Logged by:          Hajo
Email address:      hlemcke@web.de
PostgreSQL version: 9.1.2
Operating system:   Windows XP
Description:=20=20=20=20=20=20=20=20

colname =3D 'value' returns true but
colname LIKE 'value' returns false.

<hlemcke@web.de> wrote:

> colname = 'value' returns true but
> colname LIKE 'value' returns false.

Is the colname of type char(n) or does it contain trailing spaces?

-Kevin