Calculated Fields in Postgres?
| От | Jeanna Geier |
|---|---|
| Тема | Calculated Fields in Postgres? |
| Дата | |
| Msg-id | FBEGJLLJBCOMCDBJHIMEIEEECCAA.jgeier@apt-cafm.com обсуждение исходный текст |
| Ответы |
Re: Calculated Fields in Postgres?
|
| Список | 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 по дате отправления: