> >> Qual o resultado de:
> >> SELECT ID_TITULAR , NM_TITULAR, SIGLA_SOC, TP_PESSOA
> >> FROM TITULAR T
> >> WHERE (to_ascii(convert(t.nm_titular, 'LATIN1'), 'LATIN1') =
> >> to_ascii(convert(:par, 'LATIN1'), 'LATIN1'))
> >> ORDER BY NM_TITULAR;
SELECT ID_TITULAR , NM_TITULAR, SIGLA_SOC, TP_PESSOA
FROM TITULAR T
WHERE (to_ascii(convert(t.nm_titular, 'LATIN1'), 'LATIN1') =
to_ascii(convert('Sérgio', 'LATIN1'), 'LATIN1'))
ORDER BY NM_TITULAR;
ERROR: function convert(character varying, unknown) does not exist
LINE 3: WHERE (to_ascii(convert(t.nm_titular, 'LATIN1'), 'LATIN1') ...
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
