I don't like LIKE

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: I don't like LIKE
Date: 1999-06-08 13:53:01
Message-ID: 375D203D.6EE932EC@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 1999-06-08 13:56:57 Re: [HACKERS] 6.6 items
Previous Message Maarten Boekhold 1999-06-08 13:49:22 Re: [HACKERS] PID of backend