On Thu, Aug 25, 2011 at 5:08 AM, Dean Rasheed <dean.a.rash...@gmail.com> wrote: > On 25 August 2011 10:43, Vik Reykja <vikrey...@gmail.com> wrote: >> On Thu, Aug 25, 2011 at 11:39, Dean Rasheed <dean.a.rash...@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' >> > > 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.
not gonna happen. as noted, intervals already solve the issue quite well and timestamp string parsing is already complicated enough as it is. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
