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 по дате отправления: