Thread: BUG #4718: "select +'8:00'::interval;" gives an error
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
Roman Kononov escreveu: This is not a bug, but a missing feature. > 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. > You can solve it using: euler=# select '+8:00'::interval; interval ---------- 08:00:00 (1 registro) euler=# select '-8:00'::interval; interval ----------- -08:00:00 (1 registro) As pointed by Tom in an ancient thread [1], I agree that we could add + and @ unary operator for interval datatype. Unfortunately, such a patch has not been proposed yet. [1] http://archives.postgresql.org//pgsql-general/2003-09/msg00292.php -- Euler Taveira de Oliveira http://www.timbira.com/