Alvaro --- Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> escribió: > marcelo Cortez escribió: > > 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? > > The cast already exist; I think you could change its > context (from > "explicit" to "assignment" IIRC). This is, of > course, not recommended. I've created cast with assignment from in4 to text but select 23 LIKE '2%' fail. ERROR: operator does not exist: integer ~~ unknown LINE 1: select 23 LIKE '2%' ^ 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: 12 and i try with select 23 ::int4 LIKE '2%' text added explicit cast thinking in .. 'integer ~~ unknown' unknow word .. confuse to me. nothing is working any ideas? is posible to locate changes ( into sources) to revert behavior to previous 2.8x version? best regards mdc > > The operation you show is a pretty stupid thing for > a mapper to do > anyway ... I suggest you fix it. > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom > Development, 24x7 support > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list > cleanly > 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 5: don't forget to increase your free space map settings
