On Thu, Aug 25, 2011 at 11:39, Dean Rasheed
<dean.a.rasheed@gmail.com> wrote:
My first thought was to have some general way of adding or subtracting
an interval at the end of an input timestamp, eg. by adding another
couple of special values - "plus <interval>" and "minus <interval>".
This would allow things like:
TIMESTAMPTZ 'today minus 5 days'
TIMESTAMPTZ 'now plus 2 hours'
Funny you should mention intervals...
timestamptz 'today' - interval '5 days'
timestamptz 'now' + interval '2 hours'
