On Mon, Feb 24, 2003 at 19:53:00 +0200,
Victor Yegorov <viy(at)pirmabanka(dot)lv> wrote:
>
> I mean, I know the id of a root object, it's 3. If I'll extract with
> condition parent_id = 3, then I'll get only 2 rows. I'd like to have a
> recursive result set - while there are records in the table for which
> count(next_level_parent_id == this_level_child_id) > 0, select parent_id, child_id.
contrib/tablefunc will probably allow you to do what you want.