Thank's It works also in PostgreSQL! Emilio Platzer
Igor Tandetnik escribió: > "Emilio Platzer" <[EMAIL PROTECTED]> wrote > in message > news:[EMAIL PROTECTED] >> I try (and not works): >> >> CREATE TABLE nodes( >> id integer primary key, >> father_id integer, >> depth integer); >> INSERT INTO nodes (id,father_id,depth) VALUES (9,null,1); >> INSERT INTO nodes (id,father_id,depth) VALUES (99,9,null); >> update nodes set depth= >> (select f.depth+1 >> from nodes as f >> where f.id = father_id) >> where depth is null; >> SELECT * FROM nodes; > > Make it > > update nodes set depth= > (select f.depth+1 > from nodes as f > where f.id = nodes.father_id) > where depth is null; > > This time I actually tested it. It works. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
