I want to subtract the value in column lag_days
from current_date
.
Usually I would do current_date - interval '1 day'
I'm getting syntax error on the following example to subtract by days:
dkarchive=> select current_date - interval lag_days day from example_tbl;
ERROR: syntax error at or near "day"
LINE 1: select current_date - interval lag_days day from example_tb...