OR and NOT Operator Examples

The following examples use the OR and NOT operators in queries. The data source provider must support all operators in the query in order for delegation to occur. Spectrum Spatial does not delegate partial queries.

Example 1:

SELECT Obj FROM table WHERE city='Austin' OR city="Dallas"

In this example, the data source provider must support OR and = for the entire query to be delegated to the data source provider.

Example 2:

SELECT city from table where NOT MI_Envelope(obj) Within MI_Box(-180, -90,
   180, 90, 'EPSG:4326') 

If the data source provider supports NOT and Within, the entire query is delegated to the data source provider.