I don't like LIKE - Mailing list pgsql-hackers

From Thomas Lockhart
Subject I don't like LIKE
Date
Msg-id 375D203D.6EE932EC@alumni.caltech.edu
Whole thread Raw
Responses Re: [HACKERS] I don't like LIKE
Re: [HACKERS] I don't like LIKE
Re: [HACKERS] I don't like LIKE
List pgsql-hackers
There seems to be a problem with MakeIndexable(), though I haven't
confirmed that the problem lies there:

postgres=> select * from t1 where i like '2';
ERROR:  pg_atoi: error in "2ÿ": can't parse "ÿ"

istm that this query should behave itself, or at least fail in some
other way :(

I'll guess that, even though there isn't a wildcard to pattern match,
MakeIndexable() is adding a trailing \377 to the string?
               - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Dmitry Samersoff
Date:
Subject: Re: [HACKERS] Priorities for 6.6
Next
From: Don Baccus
Date:
Subject: Re: [HACKERS] 6.6 items