On Saturday, January 23, 2021, Mike Martin <
redtux1@gmail.com> wrote:
Is there any way to make the ordinality ordering to be over the entire record set rather than per array
No
(the idea is to combine two arrays of varying dimensions into one, keeping order)
I have got a working solution by adding a rowid and ordering the array by eg: rowid+nr (where rowid is 100,200, big enough not to be in record set)
Yep, this is what I often do as well.
David J.