Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1. General
Regards
Pavel Stehule
On 10/01/2008, marcelo Cortez <jmdc_marcelo@yahoo.com.ar> wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>