• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 656
  • Last Modified:

joe celko nested set model: how to compute the lft and rgt cols

Hi,

With reference to http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=235427
I want the "sql stmt" which wud give the lft and rgt col values..

0
pai_prasad
Asked:
pai_prasad
1 Solution
 
LowfatspreadCommented:
> I want the "sql stmt" which wud give the lft and rgt col values..

for WHat?

the page actually gives examples of retrieving the common information sets..

ie who are my bosses?, who am i responsible for?

Is this a HOMEWORK question?

0
 
pai_prasadAuthor Commented:
my mistake ...i cudnt quite understand wats goin on in #6 ...
and the whole article is based on lft and rgt cols...so was confused how 2 derive those...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now