Re: BUG #4821: LIKE '%_' fails - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4821: LIKE '%_' fails
Date
Msg-id 22567.1243185320@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4821: LIKE '%_' fails  ("Andrew Gierth" <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
"Andrew Gierth" <andrew@tao11.riddles.org.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

pgsql-bugs by date:

Previous
From: "Andrew Gierth"
Date:
Subject: BUG #4821: LIKE '%_' fails
Next
From: "Itagaki Takahiro"
Date:
Subject: BUG #4822: xmlattributes encodes '&' twice