On Thu, Aug 25, 2011 at 5:08 AM, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> On 25 August 2011 10:43, Vik Reykja <vikreykja@gmail.com> wrote:
>> 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'
>>
>
> 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