Re: 8.3beta bug or feature?

Pavel

--- Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> escribió:

> 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

Yes you are right, but my queries was generated for
one mapper ,explicit cast is not an option ( not
manual code here).
there any way simulate previous behavior? (automatic
conversion), create cast can help?
best regards.

mdc

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

Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo.com/