Skip to content

Instantly share code, notes, and snippets.

@maxp

maxp/xmas.sql

Created December 24, 2009 05:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save maxp/263037 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save maxp/263037 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
xmas.sql
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment