Using Recursive Common table expressions to represent Tree structures

(Leo Hsu and Regina Obe) A very long time ago, we wrote an article on how to use PostgreSQL to show the fully qualified name of an item in an inventory tree. Basically we were modeling a paper products tree. The original article can be found here Using PostgreSQL User-Defined Functions to solve the

Read More - Register for Free Membership