Re: BUG #6458: LIKE different to =

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
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-02-14 18:28:11 Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)
Previous Message Albert Cieszkowski 2012-02-14 15:39:52 Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)