Fernando Bossini escreveu: > Opa!!! > > SQL: > > select cont_codi, cont_desc > from conta > where cont_codi like '%1%' > > > ERRO NO PGADMIN: > > ERROR: operator does not exist: integer ~~ unknown > LINE 3: where cont_codi like '%1%' > ^ > HINT: No operator matches the given name and argument type(s). You > might need to add explicit type casts. > > ********** Erro ********** > > ERROR: operator does not exist: integer ~~ unknown > SQL state: 42883 > Dica: No operator matches the given name and argument type(s). You might > need to add explicit type casts. > Caracter: 56 > > > > Existe alguma forma de fazer esse sql? Um like no campo inteiro? >
Utilize cast explĂcito. cont_codi::text like '%1%' Osvaldo _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral