On Saturday, January 23, 2021, Mike Martin <redtux1(at)gmail(dot)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.