Your syntax is just a bit off. Try something like
select (column1 + column2) as "Sum" from tablename where cusid = '12123';
It works for me.
Tad Naworal wrote:
> Hi,
>
> I'm trying to add some numeric columns together
>
> select (stotal + ltotal) as total from table where cusid='12123';
>
>
> I searched the docs and could not find an answer.
> any help would be greatly appreciated
>
> thanks
> Tad
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
--
John Burski
I.T. Manager and Systems Administration
911EP
First in LEDs... The solid state warning light leader.
1-800-863-6911