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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
