Pavel --- Pavel Stehule <pavel.stehule@xxxxxxxxx> 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@xxxxxxxxxxxx> 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/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
