MySQL Forums
Forum List  »  Stored Procedures

Re: Development of touching tables in functions
Posted by: Andrew Gilfrin
Date: April 19, 2005 04:49AM

Per-Erik, Thanks very much for getting back to us. I'll have to try out some stuff later but it's good to know inserts/updates should work.

I mentioned on another thread that I thought the returning of results sets via a select statement in procedures was possibly a useful side effect rather than by design.

To answer your question Tomi, it depends on what your trying to do. When your using functions in SQL it doesn't really make much sense to return results sets, by their very nature they should be returning single values and not sets.

The reason it's not a problem is that you should be able to return table data simply by using joins etc in the actual select statement rather than doing it via a function.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.