about me and my world

Mittwoch, 23. Dezember 2009

Happy Xmas

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!

1 Kommentar:

Anonym hat gesagt…

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!