From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "marcelo Cortez" <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.3beta bug or feature? |
Date: | 2008-01-10 17:08:49 |
Message-ID: | 162867790801100908m74656b2q9ebb8ec16cd8f58d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda pgsql-general |
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(at)yahoo(dot)com(dot)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/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-10 17:12:57 | Re: 8.3beta bug or feature? |
Previous Message | marcelo Cortez | 2008-01-10 16:47:35 | 8.3beta bug or feature? |
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo | 2008-01-10 17:12:57 | Re: 8.2.4 serious slowdown |
Previous Message | Tom Lane | 2008-01-10 17:02:38 | Re: Installation problem: failed to initialize lc_messages to "" |