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
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 |
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 |