Unexpected query results

Miguel A. Juan <mjuan@cibal.es>

From: "Miguel A. Juan" <mjuan@cibal.es>
To: <pgsql-bugs@postgresql.org>
Date: 2001-04-05T07:40:56Z
Lists: 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