Re: Time intervals in select statement

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