Re: Insert trigger to enforce uniqueness

On Sun, 03 Mar 2002 20:43:59 -0500, tram wrote:

> Hi,
>
> Our third party application doesn't allow to create Unique indexes on a
> column.
> I want to write an insert trigger which allow nulls but no duplicate
> values on a column (peopleID column). Waht is the best way to write
> BEFORE INSERT TRIGGER for thsi kind of requirement? Please give sample

What kind of an application doesn't allow unique indexes on the table? What is it supposed to do? A full table scan? Use the force of the One Ring?

-- 
Mladen Gogala