Обсуждение: 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/