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?
Re: 8.3beta bug or feature? Re: 8.3beta bug or feature? |
| Список | 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 по дате отправления: