Recursiv/hierarchical query?

[Ruslan Zasukhin]

On 12/30/08 4:15 PM, "Paul Gaspar" <devlist at revolversoft.com> wrote:

Hi Paul,

Yes such feature exists in Oracle and others.
Usually very different.

SQL99? I have see in SQL99 that recursive queries can be solved with help of
CREATE TYPE, and so on. But query is on one page size.

I did have ideas of such queries for Valentina using Vlink. Not remember now
in API or on SQL I was going did it. Probably in both,

How urgent this is for you?

Please fill feature request into Mantis first of all, and point TIME you
need it.

And ... Lets continue discussion how this can be solved in best way for
Valentina.

Welcome URLs and examples of SQLs from Oracle and MSN.
Okay?




> Yes, I think its possible in MS SQL and Orcale, and part of SQL99.
> (START WITH ... CONNECT BY)
> 
> Paul
> 
> 
> 
> Am 30.12.2008 um 14:34 schrieb william humphrey:
> 
>> Without writing the joins? Is this something available in other SQL?
>> 
>> On Tue, Dec 30, 2008 at 9:22 AM, Paul Gaspar
>> <devlist at revolversoft.com>wrote:
>> 
>>> Hi all,
>>> 
>>> is there a way to create recursive/hierarchical selects within
>>> Valentina SQL?
>>> 
>>> Something which finds all childs, grandchilds and so on within a
>>> table, performs the query on every item and unions the result?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]