8.3beta bug or feature?

From: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.3beta bug or feature?
Date: 2008-01-10 16:47:35
Message-ID: 330523.66927.qm@web32108.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda 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

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Pavel Stehule 2008-01-10 17:08:49 Re: 8.3beta bug or feature?
Previous Message Guido Barosio 2008-01-10 16:47:07 Re: RV: Consultar Secuencias

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2008-01-10 16:50:57 Re: 8.2.4 serious slowdown
Previous Message Joshua D. Drake 2008-01-10 16:41:33 Re: 8.3 Beta Incompatible Data Disaster