Devrim,
> Today, one of my teacher asked me a question for a practice... I could not > solve it :) > > Here it comes: > > We are given the name of the grandfather in a family. Let's call him A. A > has n sons, each son has children . etc. In a month or so, I will be posting an article on advanced tree structure (based on Joe Celko's work) in PostgreSQL. Until then, buy a copy of SQL for Smarties, 2nd ed. by Joe Celko. He has two chapters on tree structure. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org