Re: Re: JDBC 2.0 conformance, documentation and todo list - Mailing list pgsql-jdbc

Peter Eisentraut <peter_e@gmx.net> writes:
> Barry Lind writes:
>> supportsANSI92EntryLevelSQL - Since postgres now does support outer
>> joins, I think the answer here should be yes.  I think the general
>> feeling is that if there is a deviation from entry level SQL92 it is a bug.

> Outer joins are not required for entry level SQL.  Nevertheless,
> PostgreSQL does not and probably will never comply with entry level SQL to
> the letter, so the answer "false" is correct.

I think the biggest remaining shortcoming compared to "entry SQL92" is
lack of schema support.  I haven't groveled through the spec in detail
to see what else is missing, however.  (Once we have schemas, we can
try to run the NIST compliance tests and see what they complain of...)

            regards, tom lane