"Henshall, Stuart - Design & Print" <[EMAIL PROTECTED]> writes:
> dev=# select '0 sec'::interval+'2002/10/21 09:48'::timestamptz-'2002/10/21
> 09:30'::timestamptz;
> ?column?
> --
> -09:30
> (1 row)
In 7.3 I get
regression=# select '0 sec'::interval+'2002/10/21 09:48'::timestamptz-'2002
Title: Interval+tz-tz gives unexpected result
dev=# select '0 sec'::interval+'2002/10/21 09:48'::timestamptz-'2002/10/21 09:30'::timestamptz;
?column?
--
-09:30
(1 row)
I would have expected '00:18'
dev=# select version();
version
--
sampathraghavan ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
postmaster not running
Long Description
The Posgresql 7.1
Suddenly the /etc/init.d/posgresql script is not starting it always
reporst fialure.
I want to know the