Skip to content
cicada edited this page Dec 7, 2022 · 15 revisions

title: Index permalink: /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

since version

5.15

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

Clone this wiki locally