Currently TH has the following restriction:

You can only run a function at compile time if it is imported from another module. That is, you can't define a function in a module, and call it from within a splice in the same module.

This is a pain. It should be fixed.

See http://www.haskell.org/pipermail/template-haskell/2007-October/000619.html, for example.