MIME-Version: 1.0
From: Magnus Falch <magnus.falch@gmail.com>
Date: Wed, 13 Mar 2024 14:05:02 +0100
Message-ID: 
 <CAODrA7qNoX7QqBNO_OfobjULLhNanjvZyco0wNOn7xELuY=VBw@mail.gmail.com>
Subject: Edit wiki
To: pgsql-www@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c7905706138a6cb1"
Archived-At: 
 <https://www.postgresql.org/message-id/CAODrA7qNoX7QqBNO_OfobjULLhNanjvZyco0wNOn7xELuY%3DVBw%40mail.gmail.com>
Precedence: bulk

--000000000000c7905706138a6cb1
Content-Type: text/plain; charset="UTF-8"

I would like editor access to the wiki,
my username is magnus.falch@gmail.com and I would like to modify the
array_reverse snippets to add this one:

CREATE OR REPLACE FUNCTION array_reverse_custom(input anyarray)
RETURNS anyarray
language sql
returns null on null input
parallel safe
immutable
AS $$
select array_agg(val order by pos desc) from
unnest(input) with ordinality as elem(val,pos);
$$;

--000000000000c7905706138a6cb1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">
<pre>I would like editor access to the wiki,<br>my username is <a href=3D"m=
ailto:magnus.falch@gmail.com">magnus.falch@gmail.com</a> and I would like t=
o modify the array_reverse snippets to add this one:<br><br>CREATE OR REPLA=
CE FUNCTION array_reverse_custom(input anyarray)<br>RETURNS anyarray<br>lan=
guage sql<br>returns null on null input<br>parallel safe<br>immutable <br>A=
S $$<br>select array_agg(val order by pos desc) from<br>unnest(input) with =
ordinality as elem(val,pos);<br>$$;</pre>

</div>

--000000000000c7905706138a6cb1--