DELETE FUNCION foo in PostgreSQL

Related Ads

To delete a function in PostgreSQL you don't DELETE it, you DROP it. You also have to mention the argument types, so if foo takes a varchar and an int, make sure you say so. I know, I know, basic stuff that everyone should know it, but I sure didn't! You'll have to do this before reinstantiating the function with a different template and, of course, if you just want to get rid of it.

DROP FUNCTION foo(varchar, int);