Unexpected query results

Поиск
Список
Период
Сортировка
От Miguel A. Juan
Тема Unexpected query results
Дата
Msg-id 001b01c0bda3$c01144d0$07c8a8c0@miguel2000
обсуждение исходный текст
Ответы Re: Unexpected query results  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Loosing files after backend crash
Следующее
От: Stephen Ramsay
Дата:
Сообщение: psql segmentation fault