WITH RECURSIVE ....
Swweeeeet... PostgreSQL 8.4 is out and it has support for WITH RECURSIVE which can be used for computing transitive closures of relational algebra expressions.
In plain programmer speak: You can now represent a tree in SQL and find ALL children of it(not just it its immediate children). So go forth and write all those message forums you've wanted to write all these years, but didn't because you had to find all the children of the nested messages in a loop of SQL :).
Also: MySQL sucks.
In plain programmer speak: You can now represent a tree in SQL and find ALL children of it(not just it its immediate children). So go forth and write all those message forums you've wanted to write all these years, but didn't because you had to find all the children of the nested messages in a loop of SQL :).
Also: MySQL sucks.