8.3beta bug or feature?

Поиск
Список
Период
Сортировка
От marcelo Cortez
Тема 8.3beta bug or feature?
Дата
Msg-id 330523.66927.qm@web32108.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: 8.3beta bug or feature?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: 8.3beta bug or feature?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: 8.3beta bug or feature?  (Erik Jones <erik@myemma.com>)
Список pgsql-general
folks

 the follow queries work in postgres 8.2 but
 in  8.3beta don't work


SELECT c.* FROM c WHERE  c.numero LIKE '1%';

i think automatic conversion of  numeber to text is
the problem , in 8.3beta don't work
numero field is  integer type
any ideas?

 best regards
 mdc

ps:"PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled
by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)"


ERROR:  operator does not exist: integer ~~ unknown
LINE 2:  c.numero LIKE '1%')

      ^
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: integer ~~ unknown
Estado SQL:42883
Sugerencias:No operator matches the given name and
argument type(s). You might need to add explicit type
casts.
Caracter: 141





      Tarjeta de crédito Yahoo! de Banco Supervielle.
Solicitá tu nueva Tarjeta de crédito. De tu PC directo a tu casa. www.tuprimeratarjeta.com.ar

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.3 Beta Incompatible Data Disaster
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?