Galera valeu pela força... 2007/12/13, Osvaldo Rosario Kussama <[EMAIL PROTECTED]>: > > Marcelo escreveu: > > REPLACE(TRIM(TO_CHAR(REPLACE(CAMPO, ''99G999D99'' ,'G', ' '))), ' ', > '.'); > > > > VEJA O ERRO: > > ERROR: function replace(numeric, "unknown", "unknown", "unknown") does > > not exist > > > > > Veja se ajuda: > bdteste=# SELECT > ltrim(to_char(12345.67,'999"."999"."999"."999D99'),' .'); > ltrim > ----------- > 12.345,67 > (1 registro) > > Osvaldo > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
-- Marcelo
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
