Hi,
Let's say I have tables T1,T2 and T3 with 2 columns each and I am joining
them.
The result rows will have 8 columns each.
Let's say an output of the join is:
r11,r21,r31
r11,r21,r32
r11,r21,r33
where r1i is the i th row in T1, r2i is the i th row in T2 and r3i is the
ith row in T3:
sqlite produces 3 result rows , but I would like to produce one result row
where,
r11
|
r21
/ | \
r31 r32 r33
where the results are linked and the rows r11 and r21 are not repeated.(It
is similar to an adjacency list representation)
The efficiency I gain with the 2nd approach, is the reduction is in the
number of copies .i.e each row is copied only once.
Now , I traverse the graph depth first and get the required results as
r11,r21,r31
r11,r21,r32
r11,r21,r33
are there any hacks in sqlite which does this ? or can you give me some
pointers as in how I should proceed ? I would like to have the linked
output of the join at any point of time and I will traverse the link depth
first to retrieve the individual rows.
Thanks a lot for your help .
Prakash
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
