Richard Broersma Jr wrote:
But now that I think about it, using the authors suggestion (if it actually
worked), how would
would it be possible to change the active status from one badge to another?
Well, the check constraint as you wrote it requires that there always be
a badge listed as active for each employee. If you changed
the contstraint to: CHECK ( 2 > .....) then you'd be able to unset the
active status and then set a new one to active.
--
erik jones <[EMAIL PROTECTED]>
software development
emma(r)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
