Re: 8.3beta bug or feature?

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