BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1

Поиск
Список
Период
Сортировка
От Hugo Rafael Lesme Marquez
Тема BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1
Дата
Msg-id 200803242247.m2OMlYqJ014115@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4055
Logged by:          Hugo Rafael Lesme Marquez
Email address:      hugolesme@hotmail.com
PostgreSQL version: 8.2.7 and 8.3.1
Operating system:   Windows 2003 Server SP2
Description:        Using Like in PostgreSQL 8.2.7 and 8.3.1
Details:

Using PostgreSQL Database 8.2.7 and 8.3.1

With PostgreSQL 8.2.7

select * from movimientos where idmovimientos like '178'

returns

178; "2008-02-16"; 4700.00; 2; 1; "2008-02-22 16:39:09.14"; 2; "maricel"; 2

Ok!!!

With PostgreSQL 8.3.1

select * from movimientos where idmovimientos like '178'

returns

ERROR:  operator does not exist: bigint ~~ unknown
LINE 1: select * from movimientos where idmovimientos like '178'
                                                      ^
HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.

********** Error **********

ERROR: operator does not exist: bigint ~~ unknown
SQL state: 42883
Dica: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Caracter: 47

What can I do to resolve?

Hugo

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4054: Text containing ';' upsets db restores
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1