src/tutorial/funcs.source: Wrong comment?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

src/tutorial/funcs.source: Wrong comment?

Daniel Westermann (DWE)
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



Reply | Threaded
Open this post in threaded view
|

Re: src/tutorial/funcs.source: Wrong comment?

Tom Lane-2
"Daniel Westermann (DWE)" <[hidden email]> writes:
> in "src/tutorial/funcs.source" there is this block:
> ...
> Actually it does work and I do not see a reason why this still should be commented. Thoughts?

Agreed and done.

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

Re: src/tutorial/funcs.source: Wrong comment?

Daniel Westermann (DWE)
"Daniel Westermann (DWE)" <[hidden email]> writes:
>> in "src/tutorial/funcs.source" there is this block:
>> ...
>> Actually it does work and I do not see a reason why this still should be commented. Thoughts?

>Agreed and done.

Thanks, Tom