<[EMAIL PROTECTED]> writes: > As far as I can see NIST (http://www.itl.nist.gov/div897/ctg/sql_form.htm) > tests are used *only* for testing SQL92 conformance. > Latest available test suite version 6, dated 12/1996. > Are you using about 6-7 years old test suite? > Perhaps I am wrong, I would be happy If someone could point me up-to-date > info about NIST conformance testing.
AFAIK, the NIST abandoned that project years ago, so there isn't any more-up-to-date test suite available. Not sure this is a big problem, since SQL92 is not a moving target. It'd be nice if they had kept working and developed tests for the non-entry-level features, but they didn't. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match