SQL implementation differences for the ST_Geometry type

There is little difference between the implementation of spatial SQL for Informix, DB2, and the spatial type for Oracle or PostgreSQL. ESRI, a partner and codeveloper of extended spatial SQL within the IBM database management system (DBMS) products, worked in a cooperative environment to ensure that the standards dictated by the Open Geospatial Consortium (OGC) were applied to the fullest extent possible.

There are, however, three notable exceptions, none of which actually breach the OGC standards, but are minor implementation idiosyncrasies of the DBMSs themselves.


11/18/2013