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/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
