I would also be willing to bet that most other databases don't support
entry level sql to the letter either (look at how Oracle treats the
empty string (i.e. '') as null). But I bet Oracle claims they support
entry level SQL in their JDBC driver since it is a requirement for J2EE.
I don't see any problem with claiming support for entry level even
though there are a few exceptions.
thanks,
--Barry
Peter Eisentraut wrote:
> 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.
>
>