Re: [BUGS] like operator bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] like operator bug
Date
Msg-id 27352.936711802@sss.pgh.pa.us
Whole thread Raw
In response to like operator bug  (jfaith <jfaith@cemsys.com>)
List pgsql-bugs
jfaith <jfaith@cemsys.com> writes:
> create table tst(addr char(4));
> insert into tst values('1000');
> insert into tst values('1010');
> insert into tst values('1120');
> select * from tst where addr like '1%0';
> produces
> addr
> ----
> 1120(1 row)
> where it should return all of the example rows.

You are right.  I think that's my fault :-(.  Will fix it.

> Also the bug tracking system at
>   http://www.PostgreSQL.ORG/bugs/visitor.php3
> is not functioning(I reported this like bug about 2 weeks ago slip 72 I
> think).

We have concluded that reporting bugs via the bugs email list is a
better approach than having people make direct entries into the bug
tracking system.  Theoretically the bug tracking system is for letting
people know what the status of known bugs is ... but I'm not sure if
anyone is maintaining it very diligently :-(.  The website needs to be
updated to explain that you should still submit bugs via pgsql-bugs.

            regards, tom lane

pgsql-bugs by date:

Previous
From: jfaith
Date:
Subject: like operator bug
Next
From: Frank Cusack
Date:
Subject: Bug report