what's the difference between create function f_name is and create function f_name as

thanks in advance.

You have to use AS to create a function based on EXTERNAL program (such as C method), for other types you have to use IS.