Re: BUG #6458: LIKE different to =

Lists: pgsql-bugs
From: hlemcke(at)web(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6458: LIKE different to =
Date: 2012-02-14 15:38:46
Message-ID: E1RxKSs-0000Mc-9s@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6458
Logged by: Hajo
Email address: hlemcke(at)web(dot)de
PostgreSQL version: 9.1.2
Operating system: Windows XP
Description:

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>,<hlemcke(at)web(dot)de>
Subject: Re: BUG #6458: LIKE different to =
Date: 2012-02-14 16:22:07
Message-ID: 4F3A35CF0200002500045514@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

<hlemcke(at)web(dot)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