Re: Trunc in Postgres

> You can try
> select CAST(cast('0000000000000000000000004' as NUMERIC(20)) AS varchar);

noobie question:

Do multiple casts like that slow down the query (in general and not specifically
for the query above)?  If not, what about if the query is complex?

thnx,
Chris