All,
I have a table like this one:
CREATE TABLE [WORLD] ([Continent] , [Region] , [Country] , [TreeNode] CHAR);
insert into [WORLD] values('America', null, null, '1');
insert into [WORLD] values('America', 'North', null, '1.1');
insert into [WORLD] values('America', 'Central', null, '1.2');
insert into [WORLD] values('America', 'South', null, '1.3');
insert into [WORLD] values('Europe', null, null, '2');
insert into [WORLD] values('Europe', 'West', null, '2.1');
insert into [WORLD] values('Europe', 'Central', null, '2.2');
insert into [WORLD] values('Europe', 'East', null, '2.3');
insert into [WORLD] values('America', 'North', 'USA', '1.1.1');
insert into [WORLD] values('America', 'Central', 'Honduras', '1.2.1');
insert into [WORLD] values('America', 'South', 'Peru', '1.3.1');
insert into [WORLD] values('America', 'South', 'Brasil', '1.3.2');
insert into [WORLD] values('Europe', 'West', 'Spain', '2.1.1');
insert into [WORLD] values('Europe', 'West', 'France', '2.1.2');
insert into [WORLD] values('Europe', 'Central', 'Romania', '2.2.1');
insert into [WORLD] values('Europe', 'East', 'Estonia', '2.3.1');
insert into [WORLD] values('Asia', 'East', 'Japan', '3.1.1');
insert into [WORLD] values('Asia', 'East', 'Korea', '3.1.2');
insert into [WORLD] values('Asia', 'West', 'India', '3.2.1');
insert into [WORLD] values('Africa', 'North', 'Egypt', '4.1.1');
But I would like to generate the TreeNode fields automatically.
Is there a way I can do this in SQL?
thanks
Gert
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
