Thanks, guys. This really helps out.
Andrew
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sun, Aug 23, 2009 at 09:47:06AM -0500, Andrew Cooper wrote:
> Greetings,
>
> This is a general database design question. I've got a database where I
> need to hold information on employees. Every employee has much of the
> same information so I've created an Employee table. Now, some empl
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 su
Greetings,
This is a general database design question. I've got a database where I
need to hold information on employees. Every employee has much of the
same information so I've created an Employee table. Now, some employees
are supervisors or managers. An employee can only have 1
manager
