1
If someone like me end up in this old question, nowadays loadable function were created.
According to the documentation
Use the loadable function interface. A loadable function is compiled as a library file and then loaded and unloaded from the server dynamically using the CREATE FUNCTION and DROP FUNCTION statements.
Only top voted, non community-wiki answers of a minimum length are eligible