<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Matteo Giacomazzi ha scritto:<br>
<blockquote
cite="mide47602b0612180218v5c038e30xe1f2a1a6d7fd9ec7@mail.gmail.com"
type="cite"><a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.1/en/routine-restrictions.html">http://dev.mysql.com/doc/refman/5.1/en/routine-restrictions.html</a>
<br>
<br>
Dicono che le stored procedure non possono essere ricorsive.
<br>
<br>
</blockquote>
In MySQL 5, at the moment you can't write a recursive stored functions.
It is forbidden.<br>
Instead you can write a recursive stored procedure. That is not
permitted by default but modifying a variable you can achieve such a
recursion.<br>
The variable is <code>max_sp_recursion_depth</code>.<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.planetmysql.org/entries/4244">http://www.planetmysql.org/entries/4244</a><br>
<pre class="moz-signature" cols="72">--
Michel 'ZioBudda' Morelli <a class="moz-txt-link-abbreviated" href="mailto:michel@ziobudda.net">michel@ziobudda.net</a>
Consulenza sistemistica in ambito OpenSource.
Sviluppo applicazioni web dinamiche (LAMP+Ajax)
Telefono: +39-0240706096 -- Fax: +39-0291390660
<a class="moz-txt-link-freetext" href="http://www.ziobudda.net">http://www.ziobudda.net</a> ICQ: 58351764
<a class="moz-txt-link-freetext" href="http://www.ziobuddalabs.it">http://www.ziobuddalabs.it</a> Skype: zio_budda
<a class="moz-txt-link-freetext" href="http://www.ajaxblog.it">http://www.ajaxblog.it</a>
</pre>
</body>
</html>