I don't mean "execute" function literally, just a hook or function that is added to a hook or process in the system or called directly somewhere. Adding script alone in the init on a autload module will always append it before jquery core.
The code example on that link does have a hook with with a addLink function. This will get processed at a certain point where jquery core and likely other script are already appended.
If you give us more example of what you are doing I can help.
The code Ryan posted, is how the ModuleJS does it, but as I recently found out, doing it the same way in your module init, will add it before jquery core always, so you can't use ModuleJS.
Look at the extensive thread I created also about the same subject here