Обсуждение: BUG #6458: LIKE different to =

Поиск
Список
Период
Сортировка

BUG #6458: LIKE different to =

От
hlemcke@web.de
Дата:
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.

Re: BUG #6458: LIKE different to =

От
"Kevin Grittner"
Дата:
<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