Guys,
Something seems to be broken with the time operators in 7.2b2:
regress=# select '7:00'::time - '8:00'::time;
?column?
----------
01:00
(1 row)
regress=# select '8:00'::time - '7:00'::time;
?column?
----------
-01:00
(1 row)
regress=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2b2 on i586-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Kind regards,
Manuel.