Hello,
I have two cursors.
First is for select lines from 2 tables.
This is my semi result. This result I want to sort also.
DECLARE C1 CURSOR FOR
WITH RECURSIVE PX (ID, PARENT_ID, NAME, TYPE) AS
(
SELECT ID, PARENT_ID, NAME, 1 FROM ADMIN.CAR
UNION ALL
SELECT ADDRESS.ID, ADDRESS.PARENT_ID, ADDRESS.NAME, 2 FROM ADMIN.ADDRESS, PX
WHERE PX.PARENT_ID = ADDRESS.ID
)
SELECT DISTINCT ID, PARENT_ID, NAME, TYPE FROM PX
Using next cursor I want to sort my result table (it is tree representation)
DECLARE C2 CURSOR FOR
WITH RECURSIVE PX (ID, PARENT_ID, NAME, FOLGE, TREELEVEL) AS
(SELECT ID, PARENT_ID, NAME, CHR(ID), 1 AS TREELEVEL FROM ADDRESS WHERE PARENT_ID=-1
UNION ALL
SELECT ADDRESS.ID, ADDRESS.PARENT_ID, ADDRESS.NAME,
FOLGE || lfill (CHR(ADDRESS.ID), ' ', 10), TREELEVEL + 1
FROM ADDRESS, PX
WHERE PX.id = ADDRESS.PARENT_ID
)
SELECT ID, PARENT_ID, NAME, FOLGE, TREELEVEL
FROM PX
ORDER BY FOLGE
Is it possible to combine these cursors? I want to put cursor C1 into cursor C2 (insted table ADDRESS).
Thanks for advice. Regards, Dusan
-=x=- Skontrolované antivírovým programom NOD32
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
