From: | "Rob Arnold" <rob(at)cabrion(dot)com> |
---|---|
To: | "Bruno Wolff III" <bruno(at)wolff(dot)to>, "postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: concatenate 2 numeric columns.. |
Date: | 2001-01-25 13:16:27 |
Message-ID: | 004c01c086d1$070fb290$4200fd0a@rob6kaq6gpodma |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The coalesce function can help with nulls. It takes a list of attributes or
literals and returns the first non-null value.
I use it like this:
select coalesce(numeric_attrib, 0) from some_table;
--rob
----- Original Message -----
From: "Bruno Wolff III" <bruno(at)wolff(dot)to>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 24, 2001 7:49 PM
Subject: Re: concatenate 2 numeric columns..
> 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(at)india-today(dot)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
> >
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Manuel Lorenzo Lopez | 2001-01-25 13:37:14 | Error compiling postgres 7.0.3 for AIX 4.3.2 |
Previous Message | Martin A. Marques | 2001-01-25 13:15:05 | Re: 7.1 expected features list? |