Hi,

imagine you have the following table:

CREATE TABLE SUBSCRIPTION (
SUBPK integer not null primary key,
SUBURL varchar(1024) not null
);

I want to make the SUBURL a unique one, but since it's a varchar(1024), this
doesn't work as the column length is too long.

Is there anything else I can do from the database side to ensure this field
stays unique? Can I accomplish something with triggers?

Cheers,


pieter



[Non-text portions of this message have been removed]