BUG #4718: "select +'8:00'::interval;" gives an error - Mailing list pgsql-bugs

From Roman Kononov
Subject BUG #4718: "select +'8:00'::interval;" gives an error
Date
Msg-id 200903200412.n2K4CQ0A020521@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4718: "select +'8:00'::interval;" gives an error
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4718
Logged by:          Roman Kononov
Email address:      kononov@ftml.net
PostgreSQL version: 8.3.7
Operating system:   GNU/Linux x86_64
Description:        "select +'8:00'::interval;" gives an error
Details:

test=# select +'8:00'::interval;
ERROR:  operator does not exist: + interval
LINE 1: select +'8:00'::interval;
               ^
HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.

test=# select -'8:00'::interval;
 -08:00:00

pgsql-bugs by date:

Previous
From: "Nagendra.K"
Date:
Subject: BUG #4719: Convertion of Data from MSSQL to Postgres
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4719: Convertion of Data from MSSQL to Postgres