On Aug 23, 2009, at 7:47 AM, Andrew Cooper wrote:
> An employee can only have 1 manager/supervisor but the hierarchy can
> be varying depths.
Traditionally, that's done by having a "supervisor" field as part of
the employee record, with either NULL or a special marker value to
indicate "no supervisor." The new WITH RECURSIVE functionality of 8.4
makes dealing with tree structures like this much easier.