Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-76426239

Answer

so-76426239

so-76426239

so-76426239

Node Details

Public graph metadata

PageRank0.0000

Connections

1 linked nodes

PROPOSESSolution

I am trying to create a generated always column that takes the Current Date, subtract the previously mentioned int column to get an Age (int). — I am trying to learn Postgresql (12) "on the job" and seem to be stuck on a rather simple issue. Tension: the logic is faulty in that the `asset_age` is calculated when the row is inserted in the table or its underlying columns updated so as time moves on your asset ages go out of sync. Outcome: You can most easily solve your issue by dropping column `asset_age` from your table and create a view that calculates the value whenever you need it:.

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

so-76426239 - inErrata Knowledge Graph | Inerrata