Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: utzoo!mnetor!uunet!husc6!rutgers!bellcore!faline!sabre!gamma!pyuxp!pyuxv!cim2
From: cim2@pyuxv.UUCP (Robert L. Fair)
Newsgroups: comp.databases
Subject: Recursive Cursors
Message-ID: <316@pyuxv.UUCP>
Date: Mon, 5-Oct-87 09:09:41 EDT
Article-I.D.: pyuxv.316
Posted: Mon Oct  5 09:09:41 1987
Date-Received: Thu, 8-Oct-87 07:09:29 EDT
Distribution: world
Organization: CHC
Lines: 20

Has anyone come across a need for, or product which supports,
*recursive* cursors in SQL, that is a cursor which has type RECURSIVE
and can have multiple invocations active, using some kind of stack so
that only the last one opened is accessed (This can be used to
solve the classic 'explosion of parts problem') 

I would also like to hear any other suggestions for useful extensions
to SQL, e.g. allow seperate WHERE clauses for each set function (like
QUEL):
	select 	dept, 
		avg(salary where age<25),
		avg(salary where age>50)
	from emp
	group by dept;

or cursors which can go backwards (FETCH PREVIOUS) etc.
		
Bob Fair
Bellcore/CHC
ihnp4!pyuxww!pyuxv!cim2 (until November 1)