Dann Corbit wrote:
> See:
> http://monetdb.cwi.nl/SQL/Benchmark/TPCH/
> If the result is correct, then the problem queries should be added to
> the regression test suite.
> If the result is not correct, then perhaps they could get assistance on
> proper configuration of PostgreSQL and rerun the tests.
this is a known issues and has been discussed in the past - the problem
here is that postgresql misparsed the interval syntax in older version
(not that they used 8.2 when 8.3 was long released in that test).
This has since been fixed in 8.4+ however.
Stefan