Re: repost of how to do select in a constraint

Dennis Gearon wrote:

> Can I reference a function in a column check constraint, when the function
doesn't yet exist,
> i.e. a the time of table creation?
>
> Or is it better to make the table, create the function, then alter table
with a check
> constraint?

The function has to exist before the constraint is created. If the function
depends on the table that will have the constraint, you will need to add the
constraint afterwards; however, if the function only depends on other
tables, then you can create the function before creating the table.
--
Peter Gibbs
EmKel Systems