Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6458: LIKE different to = - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #6458: LIKE different to =
Date
Msg-id 4F3A35CF0200002500045514@gw.wicourts.gov
Whole thread Raw
In response to BUG #6458: LIKE different to =  (hlemcke@web.de)
List pgsql-bugs
Tree view 
<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

pgsql-bugs by date:

Previous
From: hlemcke@web.de
Date:
Subject: BUG #6458: LIKE different to =
Next
From: Tom Lane
Date:
Subject: Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)