Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Then you would add a line in the Select stanza to show the ordinality: 
       values.ordinality AS custom_fields_ordinality


RESULT:


Extracting an array that is at the top-most level in a table

Sometimes you want to extract an array that is at the top-most hierarchical level of a table – that is, it is not embedded within any other object. An example of this is "departments" element in the folio_users.users table: