concatenate 2 numeric columns.. - Mailing list pgsql-general

hi guys
I wish to concatenate 2 columns of numeric type.. How can it be done..


Earlier i tried using the to_char function but it seems to be crashing
the backend. Any other option will be greatly appreciated..


select to_char(length,'9999D99') || to_char(breadth,'9999D99') from exhibit_distributions

This query seems to be crashing the backend when executed over the
table..  However when constrained using a appropriate where clause it
works..

Any other approach??.

Thanx
Anand