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?
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
