Re: [BUGS] Interval+tz-tz gives unexpected result

2002-11-11 Thread Tom Lane
"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

[BUGS] Interval+tz-tz gives unexpected result

2002-11-11 Thread Henshall, Stuart - Design & Print
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 --

[BUGS] Bug #813: postmaster not running

2002-11-11 Thread pgsql-bugs
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