select * from depesz; » children

Getting list of all children in “adjacency list” tree structure

March 23rd, 2009 by depesz | Tags: adjacency list, children, plpgsql, postgresql, tree | 4 comments »

So, you have a table which looks like this: # \d test Table "public.test" ...