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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
