13.2.2 Support to arrays in queries

The Gaia DR2 data model defines some fields as arrays what is not easily handled into the standard ADQL. The Gaia Archive is implementing some functions to allow basic operations with arrays within ADQL. Some examples are:

  • array_element(array,index) and array_element(array, index1, index2): Overloaded function that allows the extraction of one element from a one-dimensional or a two-dimensional array

  • array_dims(array): Function that allows to obtain the dimensions of one array

  • array_length(array, index): Allow to extract the length of one array