Received: from inet.alc.de (alc.alc.de [212.117.69.58]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA95208 for ; Mon, 29 May 2000 09:18:01 -0400 (EDT) (envelope-from modenbach@alc.de) Received: from werner.alc.de (werner.alc.de [193.28.5.70]) by inet.alc.de (8.8.5/8.8.5) with SMTP id PAA20107 for ; Mon, 29 May 2000 15:18:00 +0200 From: Werner Modenbach To: pgsql-sql@postgresql.org Subject: adding fields containing NULL values Date: Mon, 29 May 2000 13:58:31 +0200 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00052913594506.02278@werner.alc.de> Content-Transfer-Encoding: 8bit X-Archive-Number: 200005/182 Hi all! Let's say I have a table like: employee date sallary extras -------------------------------------- Name1 01-31-1999 5000.00 NULL Name1 02-29-1999 5000.00 500.00 Name1 03-31-1999 5000.00 NULL I would like to get something like: employee date total ----------------------------- Name1 01-31-1999 5000.00 Name1 02-29-1999 5500.00 Name1 03-31-1999 5000.00 Umfortunately 'select employee,date,sallary+extras as total' doesn't give the desired result because 'somevalue + NULL' is considered to be NULL. Is there any solution for my (small) problem? - Werner - BTW: I'm running PostgreSQL V 6.5.1 -- --------------------------------------- Werner Modenbach modenbach@alc.de ALC Computertechnik GmbH http://www.alc.de