select array_to_string(array_agg(chr(a[s])),'') "I wish you" from (
select a, generate_series(1,array_length(foo.a,1)) s from (
select array[72,97,112,112,121,32,88,109,97,115,33] as a
) foo
) bar;
Many thanks to all the people who developed and are developing PostgreSQL!
Abonnieren
Kommentare zum Post (Atom)
1 Kommentar:
Unfortunately PG 8.3 doesn't like that query: wants AS in front of the output_name's, doesn't know about array_length or array_agg. Fröhliche Weihnachten, anyway!
Kommentar veröffentlichen