Re: Foreign Key with Constant

On Fri, 21 Feb 2003, Gregory Wood wrote:

> Is it possible to create a foreign key that uses a constant for one of the
> fields. In other words, I want to foreign key one value into another table,

Not directly no.

> I'd rather do this without adding a 'constant' column, or messing too
> extensively without triggers, but I fear that one of these might be
> necessary.

Unfortunately I think you'll need to do either the constant column or
triggers (the SQL mandated way of solving this is probably check
constraints with subselects but we don't support that)  If you only
care about insert time on the fk table and not about moidfications to the
pk table you can get away with a simple function that you use in a check
constraint I think.