I am using pgplsql on Windows 2003, PostgreSQL 8.0.
I am trying to do some simple date arithmetic. All I wanted to do is take a
timestamp
(example: 2005-08-08 16:15:30) without a timezone, and substract a computed
number
of minutes and seconds (such as 310 seconds) from it; keep running into
problems.
Have tried using age(), INTERVAL, and other different approaches. Does
anybody
have a clue how to make this work simply?