http://www.commandprompt.com/blogs/aurynn_shaw/ Command Prompt Blog Feed: Aurynn Shaw's Blog Mon, 08 Oct 2007 18:58:33 -0700 www.commandprompt.com http://www.commandprompt.com/images/small_mammoth.gif http://www.commandprompt.com/blogs/aurynn_shaw/ 46 46 http://www.commandprompt.com/blogs/aurynn_shaw/2007/10/recursive_plpgsql_lookup_table_and_ltree/ Mon, 08 Oct 2007 18:58:33 -0700 http://www.commandprompt.com/blogs/aurynn_shaw/2007/10/recursive_plpgsql_lookup_table_and_ltree/ There are many reasons and needs to implement a tree structure inside of an SQL database. In our particular example today, we're using a basic knowledge base tree as an example of a small- to large-scale tree inside of an SQL database. Additionally, any sort of directory/file system layout would be a good match for these concepts. http://www.commandprompt.com/blogs/aurynn_shaw/2007/10/recursive_plpgsql_lookup_table_and_ltree/