Calculated Fields in Postgres? - Mailing list pgsql-jdbc

From Jeanna Geier
Subject Calculated Fields in Postgres?
Date
Msg-id FBEGJLLJBCOMCDBJHIMEIEEECCAA.jgeier@apt-cafm.com
Whole thread Raw
Responses Re: Calculated Fields in Postgres?
List pgsql-jdbc
Hello List!

Still trying to learn Postgres... =)  I have a question on how/where to
define a calculated field in a table...

Let's say I have a 'Replacement Cost' table with the following fields:

Original Cost
Original Date
Life Expectancy
Life Units

and I want to add a 'Mfg. Replace Date' field, which is a calculated field
with the following formula:

IF ('Life Units' = NAV)
 THEN (NAV)
ELSE
 ( IF ('Life Units' = 'Day(s)'')
     THEN (AddDate('Original Date,0,0,'Life Expectancy'))
ELSE
 ( IF 'Life Units'  = 'Month(s)'')
     THEN (AddDate('Original Date',0,'Life Expectancy',0))
ELSE
  ( IF 'Life Units' = 'Year(s)'')
     THEN (AddDate('Original Date','Life Expectancy',0.0))
ELSE
(today))))

--------------------------------------------------------

How/where do I define this calculated field?

Any help or guidance that anyone could provide will be greatly appreciated!

If any more information is necessary from my end, please let me know.

Thanks,
-Jeanna


pgsql-jdbc by date:

Previous
From: Andrew Lazarus
Date:
Subject: Re: Help with RULES - Please!
Next
From: "Andres Olarte"
Date:
Subject: Re: Calculated Fields in Postgres?