GLHI Database HTML Dump
Previous topic Chapter index Next topic

Operators

 

Operator

Schema

Owner

Function

Left Operand Type

Right Operand Type

Commutator

Negator

Restrict Function

Join Function

Left Sort Operator

Right Sort Operator

Less Than Operator

Greater Than Operator

Hash Joins

Merge Joins

Description

&&

public

wetlands

public.geometry_overlap

public.geometry

public.geometry

&&

 

public.postgis_gist_sel

public.postgis_gist_joinsel

 

 

 

 

 

 

 

&<

public

wetlands

public.geometry_overleft

public.geometry

public.geometry

&>

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

&<|

public

wetlands

public.geometry_overbelow

public.geometry

public.geometry

|&>

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

&>

public

wetlands

public.geometry_overright

public.geometry

public.geometry

&<

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

<

public

wetlands

public.geometry_lt

public.geometry

public.geometry

>

>=

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

<<

public

wetlands

public.geometry_left

public.geometry

public.geometry

>>

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

<<|

public

wetlands

public.geometry_below

public.geometry

public.geometry

|>>

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

<=

public

wetlands

public.geometry_le

public.geometry

public.geometry

>=

>

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

=

public

wetlands

public.geometry_eq

public.geometry

public.geometry

=

 

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

>

public

wetlands

public.geometry_gt

public.geometry

public.geometry

<

<=

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

>=

public

wetlands

public.geometry_ge

public.geometry

public.geometry

<=

<

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

>>

public

wetlands

public.geometry_right

public.geometry

public.geometry

<<

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

@

public

wetlands

public.geometry_contained

public.geometry

public.geometry

~

 

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

|&>

public

wetlands

public.geometry_overabove

public.geometry

public.geometry

&<|

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

|>>

public

wetlands

public.geometry_above

public.geometry

public.geometry

<<|

 

pg_catalog.positionsel

pg_catalog.positionjoinsel

 

 

 

 

 

 

 

~

public

wetlands

public.geometry_contain

public.geometry

public.geometry

@

 

pg_catalog.contsel

pg_catalog.contjoinsel

 

 

 

 

 

 

 

~=

public

wetlands

public.geometry_same

public.geometry

public.geometry

~=

 

pg_catalog.eqsel

pg_catalog.eqjoinsel

 

 

 

 

 

 

 

Pete Giencke
pgiencke@glc.org
Previous topic Chapter index Next topic