Hi,
in "src/tutorial/funcs.source" there is this block:
-----------------------------
-- Creating SQL Functions with multiple SQL statements
-- you can also create functions that do more than just a SELECT.
--
-- 14MAR99 Clark Evans: Does not quite work, commented out for now.
--
-----------------------------
-- you may have noticed that Andy has a negative salary. We'll create a
-- function that removes employees with negative salaries.
--
-- SELECT * FROM EMP;
--
-- CREATE FUNCTION clean_EMP () RETURNS integer
-- AS 'DELETE FROM EMP WHERE EMP.salary <= 0;
-- SELECT 1 AS ignore_this'
-- LANGUAGE SQL;
--
-- SELECT clean_EMP();
--
-- SELECT * FROM EMP;
Actually it does work and I do not see a reason why this still should be commented. Thoughts?
Regards
Daniel