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
