The DROP function was modified.
The DROP function was modified.

DROP FUNCTION f_name;
It will drop the function f_name if there is only one function with such name.
If there are more function and error message is sent to ask you for the complete
signature.

DROP FUNCTION f_name();
It will drop the function f_name which does not have parameters.

DROP FUNCTION f_name(int, varchar(1024));
It will drop the function with this signature.
Note: The number bits for varchar it is only checked by the parser, semantically only the type is checked not the size.
The parser need to be fixed (maybe by Niels) to avoid this inconvenient.

DROP ALL FUNCTION f_name;
It will drop all the functions with the name f_name.

Note: In all the previous case the drop can be cascade.
Syntax:

DROP FUNCTION f_name [(type_list)] [CASCADE | RESTRICT];
DROP ALL FUNCTION f_name [CASCADE | RESTRICT]

zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb