PostgreSQL - reverse order not strings

Question

in psql if a value is '03 0F 0E AB 0B 05 0E E4'

And I want it to be - E4 0E 05 0B AB 0E 0F 03 order is reversed but strings haven't.

is it possible? The reverse function reverses it to ' 4E E0 50 B0 BA E0 F0 30

WTH are you using EXECUTE everywhere? There's nothing dynamic about these queries. — Bergi
– Bergi, Commented Jan 14, 2022 at 8:09
At my work place all the queries are Dynamic - hence I am asked to put everything in dynamic. :( — user17476256
– user17476256, Commented Jan 14, 2022 at 8:11

LukStorms · Accepted Answer · 2022-02-16 12:22:15Z

1

select string_agg( unnest, ' ' order by ordinality desc) 
from unnest(regexp_split_to_array('03 0F 0E AB 0B 05 0E E4', ' ')) 
WITH ORDINALITY;

LukStorms

29.8k5 gold badges36 silver badges49 bronze badges

answered Feb 16, 2022 at 12:13

user17476256

311 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1