Hi,
> I have a table where I would like members of a uid field to be limited
> by the range of values that are in another field. What I am looking for
> would be taken care of with the enum() operator except I need the range
> of values to be dynamic - because uid will change. I've been told that
> foreign key constraints is what I want for this problem but I wonder do
> they have to be foreign? All I want is a dynamic enum constraint for on
> column depending on the values in another, within the same table.
As far as I know, ENUMs cannot be "dynamic".
So yes, they have to be FKs.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.