Usage

>psql -c "select vector_reverse('2,20,200')"

 vector_reverse
----------------
 {200,20,2}
(1 row)

Ilman otsikoita psql -t ...

Koodi

-- FUNCTION: public.vector_reverse(text)

CREATE OR REPLACE FUNCTION public.vector_reverse(
	in1 text)
    RETURNS integer[]
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE PARALLEL UNSAFE
AS $BODY$
declare
	arr integer[];

begin
arr := array_reverse(string_to_array(in1,',')::integer[]);

return arr;
end
$BODY$;

ALTER FUNCTION public.vector_reverse(text)
    OWNER TO postgres;