thanks! seems to be 6.5.1 bug. 6.5.2 should work.
not tested tho. I need to get a linux box myself :-).
On Wed, 16 Feb 2000, jose wrote:
> Is there any space after last 6 ?
>
> prova=> select * from one where descr like '%6';
> descr
> -----
> (0 rows)
>
> prova=> select * from one where trim(descr) like '%6';
> descr
> ------------
> 1236
> 12366
> (2 rows)
>
>
> Jose'
>
> kaiq@realtyideas.com ha scritto:
>
> > select listid from mylist where listid like '%6';
> >
> > to get all list ended with 6. but it does not match 66, 23466,
> > i.e., anything tht ended with 66.
> >
> >
>
> > if I use %66, then, it does not match %666 -- altho weird, it is
> > consistent.
> >
> > more genereally, anything that has 6 except in the end will not
> > match '%6' !!!
> >
> > Now i'm going to use ~ or ~*. but they are not portable. Seems that
> > "like" is somehow borken.
> >
> > I'm using 6.5.1, and I checked the release history of 6.5.2 and 6.5.3,
> > in 6.5.2 there is:
> > Repair logic error in LIKE: should not return LIKE_ABORT
> > when reach end of pattern before end of text(Tom)
> > however, I can not upgrade now.
> >
> > anybody can explain?
> >
> > thanks
> >
> > ************
>
