On 25 August 2011 10:43, Vik Reykja <[email protected]> wrote: > On Thu, Aug 25, 2011 at 11:39, Dean Rasheed <[email protected]> > 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' >
Yes, but what I am trying to achieve is a way of entering such relative timestamps using a single input value, so that absolute and relative timestamps can both be bound to a SQL query using just one variable. Regards, Dean -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
