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

From Bruno Wolff III
Subject Re: concatenate 2 numeric columns..
Date
Msg-id 20010124184906.B11151@wolff.to
Whole thread Raw
In response to concatenate 2 numeric columns..  (Anand Raman <araman@india-today.com>)
List pgsql-general
I saw some similar things when using to_char on columns will null
values. I used a case statement to check for nulls in 7.0.3. When
I switched to using 7.1beta3, the problem was fixed.

On Thu, Jan 25, 2001 at 01:42:44AM +0530,
  Anand Raman <araman@india-today.com> wrote:
> 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
>

pgsql-general by date:

Previous
From: "David Wall"
Date:
Subject: Re: MySQL has transactions
Next
From: "David Wall"
Date:
Subject: Re: Re: 7.1 expected features list?