/*PGR-GNU*****************************************************************

File: _array_reverse.sql

Copyright (c) 2016-2026 pgRouting developers

Mail: project@pgrouting.org

------

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

********************************************************************PGR-GNU*/

--v3.0

CREATE FUNCTION _pgr_array_reverse(anyarray) RETURNS anyarray AS $$

SELECT ARRAY(

SELECT $1[i]

FROM generate_subscripts($1,1) AS s(i)

ORDER BY i DESC

);

$$ LANGUAGE 'sql' STRICT IMMUTABLE;

COMMENT ON FUNCTION _pgr_array_reverse(ANYARRAY)

IS 'pgRouting internal function';