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.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
