Unexpected query results - Mailing list pgsql-bugs

From Miguel A. Juan
Subject Unexpected query results
Date
Msg-id 001b01c0bda3$c01144d0$07c8a8c0@miguel2000
Whole thread Raw
Responses Re: Unexpected query results
List pgsql-bugs
Hello,

 I've encountered with a problem running a query that with previous releases
 worked fine.

 Thats the query:
 SELECT * FROM diagnostics where codigo LIKE '103.%';

 the string in the like statment could be any code, including any character
in [ 'A' - 'Z', '.' , '0' - '9'].

 With previous releases that returns all the records that 'codigo' begins
 with '103.' but with release 7.03 this returns 0 rows. If I write  LIKE
 '103%' it works again, but I must filter for codes with the dot.

 The field type for codigo is character varying(6)

 Thanks

 Miguel Juan
Mallorca - Spain

pgsql-bugs by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Loosing files after backend crash
Next
From: Stephen Ramsay
Date:
Subject: psql segmentation fault