> > Is it possible to make a field unique without specifying an
> > index on it?

At 06:56 PM 28-06-02 -0400, Sean Leyne wrote:

>Technically, yes.
>
>Partically, no.
>
>You could create a trigger which would need to perform a select to
>ensure/enforce uniqueness, but if the table is large... that could end
>up being a very expensive/time consuming process.

Not just that, but it has to be reiterated that enforcing uniqueness by
trigger is not multi-user safe.

>A unique index is really the way to go.

Hmmm, well, a unique constraint, anyway.

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________