2008/6/4 Fernando Bossini <[EMAIL PROTECTED]>: > 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? > Like trabalha com strings, daí a mensagem do PGAdmin. Talvez fazendo cast do retorno do like.
-- Ribamar FS - [EMAIL PROTECTED] http://ribafs.net
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
