Index

Relational functions index

syntax

• index(a)

definition

index(a) results in an index attribute based on the sort order of the values in attribute a.

If two values are identical in attribute a, the first occurring value receives the lowest index number.

applies to

• attribute a with Numeric, Point, uint2, uint4, bool or string value type

example

attribute indexTemp (Region) := index(Temperature)

Temperature		indexTemp
12	3
11	6
null	2
11	4
14	1
null	5
14	7

domain Region, nr of rows = 7