> Existe alguma forma de fazer esse sql? Um like no campo inteiro?
O Operador LIKE é utilizado para STRINGS [1]!
Faça um CAST para TEXT;
SELECT '1%' like 123456::text
[1]
trisso-> \do ~~
pg_catalog | ~~ | bytea | bytea
| boolean | matches LIKE expression
pg_catalog | ~~ | character | text
| boolean | matches LIKE expression
pg_catalog | ~~ | name | text
| boolean | matches LIKE expression
pg_catalog | ~~ | text | text
| boolean | matches LIKE expression
--
Att:
Thiago Risso
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
