Perhaps this...? It would work, but depending how many rows are in the table, it could become incredibly slow.
The max rows in either table would be about 1000 or so, which isn't too many. There also should be a hole lot of inserting going on.
ALTER TABLE table1 ADD CHECK (extension NOT IN (SELECT extension FROM table2));
I guess this is the functionality i was looking for but was hoping there would be a cleaner way to do it. Anyways, thanks to everyone who replied. I'll look into each of the proposed solutions to see what best suits my needs. If anyone has a different solution i'd still like to hear it. Jon ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
