concatenate 2 numeric columns..

From: Anand Raman <araman(at)india-today(dot)com>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: concatenate 2 numeric columns..
Date: 2001-01-24 20:12:44
Message-ID: 20010125014243.G32124@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anand Raman 2001-01-24 20:20:43 scrolling in psql..
Previous Message Barry Lind 2001-01-24 20:12:36 Re: [GENERAL] jdbc driver, error trapping.