Re: Interval aggregate regression failure (expected seems

Michael Paesold wrote:
>> On Nov 7, 2005, at 17:24 , Michael Paesold wrote:
>>
>>> Using both PostgreSQL 8.1.0 and CVS current of Nov 7, 9:00 am CET I
>>> get a regression failure in the interval tests. I am no export for
>>> the interval type, but the expected "9 days 28 hours" seem wrong,
>>> don't they? The actual value seems to be the same.
>>>
>>> Is it possible that this is broken on the platform where the
>>> expected results were generated?

> Perhaps it is an intended behavior? If so, it still fails without
> integer-datetimes.

Well, no, it also fails with integer-datetimes for me in the same way.
pg_config output below. And yes, I did "cvs up; make distclean;
./configure... ; make ; make install ; make check".

Could this be DST-related? I thought plain interval was not affected by
DST changes.

BINDIR = /usr/local/postgresql-8cvs/bin
DOCDIR = /usr/local/postgresql-8cvs/doc
INCLUDEDIR = /usr/local/postgresql-8cvs/include
PKGINCLUDEDIR = /usr/local/postgresql-8cvs/include
INCLUDEDIR-SERVER = /usr/local/postgresql-8cvs/include/server
LIBDIR = /usr/local/postgresql-8cvs/lib
PKGLIBDIR = /usr/local/postgresql-8cvs/lib
LOCALEDIR =
MANDIR = /usr/local/postgresql-8cvs/man
SHAREDIR = /usr/local/postgresql-8cvs/share
SYSCONFDIR = /usr/local/postgresql-8cvs/etc
PGXS = /usr/local/postgresql-8cvs/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/local/postgresql-8cvs' '--with-pgport=54321'
'--with-perl' 'CFLAGS=-O2 -mcpu=pentium4 -march=pentium4'
'--enable-casserts' '--enable-debug' '--enable-integer-datetimes'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -mcpu=pentium4 -march=pentium4 -Wall -Wmissing-prototypes
-Wpointer-arith -Winline -Wdeclaration-after-statement
-fno-strict-aliasing -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,/usr/local/postgresql-8cvs/lib
LDFLAGS_SL =
LIBS = -lpgport -lz -lreadline -lncurses -lcrypt -lresolv -lnsl -ldl -lm
-lbsd
VERSION = PostgreSQL 8.2devel

Best Regards,
Michael Paesold