Re: recursive sql statement

2003-07-10 Thread Victoria Reznichenko
"Bernhard Schmidt" <[EMAIL PROTECTED]> wrote: > sorry for this mysql newbie question, but what means "planned for the near future"? > ist this weeks, months or years away? As to "CONNECT BY" it means the beginning of the next year. -- For technical support contracts, goto https://order.mysql.

RE: recursive sql statement

2003-07-09 Thread Kevin Fries
nal Message- > From: Knepley, Jim [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 11:35 AM > To: [EMAIL PROTECTED] > Subject: re: recursive sql statement > > > See http://www.mysql.com/doc/en/TODO_future.html > "Oracle-like CONNECT BY PRIOR ... to search tr

re: recursive sql statement

2003-07-09 Thread Knepley, Jim
See http://www.mysql.com/doc/en/TODO_future.html "Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical) structures." Whatever their definition of "The Near Future" is... I'd guess v5 J - Original Message - From: "Bernhard Schmidt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

RE: recursive sql statement

2003-07-09 Thread Rudy Metzger
Everything from month to years. Might even be tomorrow... /rudy -Original Message- From: Bernhard Schmidt [mailto:[EMAIL PROTECTED] Sent: woensdag 9 juli 2003 16:07 To: [EMAIL PROTECTED] Subject: Re: recursive sql statement hi victoria sorry for this mysql newbie question, but what

Re: recursive sql statement

2003-07-09 Thread Bernhard Schmidt
hi victoria sorry for this mysql newbie question, but what means "planned for the near future"? ist this weeks, months or years away? best regards benny

Re: recursive sql statement

2003-07-09 Thread Victoria Reznichenko
"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

Re: recursive sql statement

2003-07-09 Thread Nils Valentin
Hi Benny, Thank you for the explanation, but I believe thats out of my reach to give any advice here ;-) Best regards 2003年 7月 9日 水曜日 21:30、Bernhard Schmidt さんは書きました: > for me a recursive sql statement is when the result of a query can be used > for a following query. the statement has start a

Re: recursive sql statement

2003-07-09 Thread Bernhard Schmidt
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 r

Re: recursive sql statement

2003-07-09 Thread Nils Valentin
Hi Benny, May I guess that you are talking about nested queries or subseects ? If yes than they are supported from Version 4.1. If no, than I have no clue what you are talking about ;-) Best regards Nils Valentin Tokyo/Japan 2003年 7月 9日 水曜日 20:26、Gerald R. Jensen さんは書きました: > Benny: > > What d

Re: recursive sql statement

2003-07-09 Thread Gerald R. Jensen
Benny: What do you mean by 'recursive sql statements'? If you are talking about triggers and stored procedures, the answer is no. Gerald Jensen - Original Message - From: "Bernhard Schmidt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 2:58 AM Subject: recu