A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iirange Catalog
 
Share this page                  
iirange Catalog
The iirange catalog contains the range values for an rtree index.
Column Name
Data Type
Description
rng_baseid
integer
Identifier for the base table
rng_indexid
integer
Identifier for the rtree index table
rng_ll1
float8
Lower-left coordinate of range box for the first dimension
rng_ll2
float8
Lower-left coordinate of range box for the second dimension
rng_ll3
float8
Lower-left coordinate of range box for the third dimension. This column is currently not in use.
rng_ll4
float8
Lower-left coordinate of range box for the forth dimension. This column is currently not in use.
rng_ur1
float8
Upper-right coordinate of range box for the first dimension
rng_ur2
float8
Upper-right coordinate of range box for the second dimension
rng_ur3
float8
Upper-right coordinate of range box for the third dimension. This column is currently not in use.
rng_ur4
float8
Upper-right coordinate of range box for the forth dimension. This column is currently not in use.
rng_dimension
smallint
Dimension of range box
Currently, the value is 2.
rng_hilbertsize
smallint
The size of the hilbert function for the range
rng_rangedt
smallint
The data type of the range box, either box or ibox
rng_rangetype
char(1)
The data type of the range box's coordinates:
I if integer
F if float