Hello, it isn't bug. You have to cast to string before. http://www.postgresql.org/docs/8.3/static/release-8-3.htmlE.1.2.1. General RegardsPavel 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/> ---------------------------(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
