| 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 |