Ordering of arrays
Mike Martin <[email protected]> Fri, 23 Aug 2019 11:12:44 +0100
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAOwYNKZ-FzDtNe_UTckhbBnq6nCk4UTqHRUafmf5NUN9wMmCQg@mail.gmail.com> |
A question about arrays.
Is iit possible to reverse an array array?
for example
regexp_split_to_array(/srv/progs/programs/Aliens/The_Aliens_1_ens_envsc2_envsc2.mp4,'('/|\.)'),
which splits on either / or . to extract fileparts
It would be useful to be able to have the array returned reversed, so
rather than having to use cardinality(array)-1 I have a reversed array and
say arr[1]
Also it seems impossible to get a reverse slice (returns null array)
thanks