Re: PostgreSQL TPC-H test result? - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL TPC-H test result?
Date
Msg-id 24765.1220992015@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL TPC-H test result?  (Robert Treat <robert@omniti.com>)
Responses Re: PostgreSQL TPC-H test result?  (Simon Riggs <simon@2ndQuadrant.com>)
Re: PostgreSQL TPC-H test result?  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-general
Robert Treat <robert@omniti.com> writes:
> http://www.it.iitb.ac.in/~chetanv/personal/acads/db/report_html/node10.html.
> It isn't terribly informative, but it doesindicate one thing, someone else
> was able to run query #6 correctly, while the above site claims it returns an
> error. Now when I look at query#6 from that site, I notice it shows the
> following syntax:

> interval '1' year.

> when I saw that, it jumped out at me as something that could be an issue, and
> it is:

Yeah.  This is SQL spec syntax, but it's not fully implemented in
Postgres: the grammar supports it but the info doesn't get propagated to
interval_in, and interval_in wouldn't know what to do even if it did
have the information that there was a YEAR qualifier after the literal.

That's probably not good because it *looks* like we support the syntax,
but in fact produce non-spec-compliant results.  I think it might be
better if we threw an error.

Or someone could try to make it work, but given that no one has taken
the slightest interest since Tom Lockhart left the project, I wouldn't
hold my breath waiting for that.

            regards, tom lane

pgsql-general by date:

Previous
From: "Darren Weber"
Date:
Subject: Re: OS X library path issues for libpq (ver 8.3)
Next
From: "David Jaquay"
Date:
Subject: LEFT JOIN issue