Re: Time intervals in select statement - Mailing list pgsql-bugs

Tom

Yes, that does indeed work.

It's interesting why addition assumes one operand is interval while
subtraction assumes it is timestamp? It should at least be consistent, IMHO.

Cheers
Luke

Tom Lane wrote:

>Luke McFarlane <luke@fisheye.com.au> writes:
>
>
>>SELECT create_time, create_time - '8 days 16:49:22.600601' FROM foo;
>>
>>
>
>
>
>>ERROR:  invalid input syntax for type timestamp: "8 days 16:49:22.600601"
>>
>>
>
>Cast the constant to interval explicitly.
>
>            regards, tom lane
>
>