Andrew Sullivan sez:
} On Fri, Jun 07, 2002 at 02:36:35PM -0400, Gregory Seidman wrote:
}
} > I am in the exact same position. I have a number of things which are
} > essentially enumerations. Since PostgreSQL does not support an enumeration
} > type (MySQL does, but then it doesn't have a proper boolean type), I have a
}
} Why don't you use a CHECK contraint? That's the standard way to do
} it.
Er, could you expand on that? Are you suggesting something like this:
CREATE TABLE Foo (
KindID int,
...
CONSTRAINT fooenum
CHECK KindID IN ('SOFTWARE', 'HARDWARE')
);
} A
--Greg