Auto column update in postgis

Question

I have a fruit orchard dataset. One of the columns contain the year the orchard was planted. In another column I would like to have the orchard age. However this pose a problem, since the age changes every year.

My question: Is it possible to auto calculate orchard age based on the year column in postgis? If it is possible, please specify how.

score 6 · Accepted Answer · edited Apr 13 '17 at 12:34

6

Make a view in PostgreSQL, where the age column can be dynamically created using some useful functions:

SELECT date_trunc('month', age(now()::date, '1994-03-19'::date)) AS age;
       age
-----------------
 19 years 5 mons
(1 row)

edited Apr 13 '17 at 12:34

Community

1

answered Sep 03 '13 at 11:30

Mike T

42,095
10
126
187

Auto column update in postgis

1 Answers1