Path: utzoo!attcan!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: SQL Poser
Message-ID: <905@dgis.dtic.dla.mil>
Date: 29 Jun 90 02:17:33 GMT
References: <6588@umd5.umd.edu> <355@brontolo.sublink.ORG> <8514@cognos.UUCP>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 19

garyp@cognos.UUCP (Gary Puckering) writes:

>A more beautiful answer to this problem can be found in PowerHouse
>StarBase (from Cognos) and in InterBase (from Interbase Software
>Corporation).  You can code requests that will be instantiated each
>time a recursive procedure calls itself.

Clearly a better solution than is available through standard SQL.  The
program is cleaner to write and easier to read.  However, from your
code it appears that your engine doesn't support recursive queries,
rather your query language allows programs recursively to submit many
ordinary queries.  Is this true?  If so, one still writes a recursive
program instead of a query, and performance will still be inherently
poor.  If not, could you give us an example of a recursive query?

-- Jon
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
Drop in next time you're in the tri-planet area!