"Bernhard Schmidt" <[EMAIL PROTECTED]> wrote:
>
> for me a recursive sql statement is when the result of a query can be used for a
> following query. the statement has start and stop condition. such kind of queries is
> useful for tree traversal. sql is based on relational algebra that does not allow to
> write such expressions. but as mentioned by rudy metzger some databases defines
> extensions to sql, oracle uses "connect by". db2 has another apporach using "with".
>
"CONNECT BY" currently is not supported, but it's in TODO list:
http://www.mysql.com/doc/en/TODO_future.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
