Postgres Pro
Downloads
Home   >   mailing lists

Re: Null Conversion - Mailing list pgsql-general

From Jason Turner
Subject Re: Null Conversion
Date
Msg-id 20010815132003.A3098@camille.indigoindustrial.co.nz
Whole thread Raw
In response to Null Conversion  (Mike Withers <M.withers@uws.edu.au>)
List pgsql-general
Tree view 
> Can anyone tell me how I might convert a null attribute value into a zero
> attribute value such that it can be multiplied in a query.
>
> In Oracle I could do:
>
> sal*12*NVL(COMM, 0) AS "Annual Income"

sal * 12 * CAST(COMM AS float8) AS "Annual Income"

Cheers

Jason
--
Indigo Industrial Controls Ltd.
64-21-343-545
jasont@indigoindustrial.co.nz

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Null Conversion
Next
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: nextval, sequences and sequencenames