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.