> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a constraint so
> that the values are not repeated in any order? I want to make sure that
> rows such as 2 and 4 in the example below cannot happen. This is a very
> small table that is meta data for an application. It is only 41 rows now
> and probably won't grow beyond 200 rows. I am on Postgresql ver 7.3.4 .
>
> id fkey1 fkey2
> 1 3 4
> 2 10 4
> 3 2 7
> 4 4 10
> 5 15 8
CREATE TABLE junction
(
);
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
