[Db] Store procedure mysql5 ricorsive

[Davide Michel 'ZioBudda' Morelli]

Matteo Giacomazzi ha scritto:
> http://dev.mysql.com/doc/refman/5.1/en/routine-restrictions.html
>
> Dicono che le stored procedure non possono essere ricorsive.
>
In MySQL 5, at the moment you can't write a recursive stored functions. 
It is forbidden.
Instead you can write a recursive stored procedure. That is not 
permitted by default but modifying a variable you can achieve such a 
recursion.
The variable is |max_sp_recursion_depth|.

http://www.planetmysql.org/entries/4244

-- 
Michel 'ZioBudda' Morelli                       michel a ziobudda.net
Consulenza sistemistica in ambito OpenSource.
Sviluppo applicazioni web dinamiche (LAMP+Ajax)
Telefono: +39-0240706096 --  Fax: +39-0291390660

http://www.ziobudda.net                         ICQ: 58351764  
http://www.ziobuddalabs.it                      Skype: zio_budda
http://www.ajaxblog.it                           

-------------- parte successiva --------------
Un allegato HTML è stato rimosso...
URL: http://lists.ziobudda.net/pipermail/db/attachments/20061218/94e35390/attachment.htm