Skip to content

Widgets for Arrays

bstroebl edited this page Jan 19, 2015 · 14 revisions

The plugin supports PostgreSQL arrays of the same data types as it does for simple widgets except for the text data type (does not make too much sense anyways).

widget for an integer array

widget for an integer array

Features

  • You can add, delete and edit elements in an array.
  • Arrays can hold NULL values in order to have a certain number of elements in the array.
  • Arrays may not be totally empty (NULL) if there is a NotNULL-constraint defined on the field.
  • You can configure input widgets for arrays in exactly the same way as you do for other fields.
  • You can search for features where at least one of its array elements follows a certain criterion (ANY).
  • You can search for features where all array elements follow a certain criterion (ALL).
  • When searching you can combine several criterions with either AND or OR.

Refer to the PostgreSQL's documentation on how to define arrays and how to search in them.

Clone this wiki locally