Mike,
connectby() is your friend here. Do a search on tablefunc in the help file.
CREATE Table wallposts
(
id uuid NOT NULL,
posted timestamp NOT NULL,
userid uuid NOT NULL,
posterid uuid NOT NULL,
parentid uuid NOT NULL,
comment text NOT NULL
)
SELECT * FROM connectby('wallposts', 'id', '
Hi guys -
I'm looking for the best way to store a set of "posts" as well as
comments on those posts in SQL. Imagine a design similar to a "Wall" on
Facebook where users can write posts on their wall and other users can
comment on those posts. I need to be able to display all wall posts as
w