From: | Grant Finnemore <gaf(at)ucs(dot)co(dot)za> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | Werner Modenbach <modenbach(at)alc(dot)de> |
Subject: | Re: adding fields containing NULL values |
Date: | 2000-05-29 13:43:07 |
Message-ID: | 393273EB.225F9DA5@ucs.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Werner,
> 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?
Try
SELECT employee, date, salary + COALESCE(extras, 0) as total FROM ...
Regards
Grant
--
> Poorly planned software requires a genius to write it
> and a hero to use it.
Grant Finnemore BSc(Eng) (mailto:gaf(at)ucs(dot)co(dot)za)
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein
Fax (+27)(11)339-3421 Johannesburg, South Africa
From | Date | Subject | |
---|---|---|---|
Next Message | Bernie Huang | 2000-05-29 16:21:20 | template or index of some kind |
Previous Message | Werner Modenbach | 2000-05-29 11:58:31 | adding fields containing NULL values |