Re: BUG #4821: LIKE '%_' fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Gierth" <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4821: LIKE '%_' fails
Date: 2009-05-24 17:15:20
Message-ID: 22567.1243185320@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andrew Gierth" <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> # select 'foo' like '%_';
> ?column?
> ----------
> f
> (1 row)

> correct result would be 't'

Hmmm ... there's actually special-case code for '%_' in there,
but it seems to be just plain broken.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Itagaki Takahiro 2009-05-25 09:39:39 BUG #4822: xmlattributes encodes '&' twice
Previous Message Andrew Gierth 2009-05-23 01:01:52 BUG #4821: LIKE '%_' fails