On 11/11/2014 5:32 PM, David G Johnston wrote:
Bill's solution: PRIMARY KEY (person1, person2), CHECK (person1 < person2) seems to make this constraint fairly simple...am I missing something?
oh, I guess I missed that part. of course, you'll have to make sure you swap any relation into lesser,greater before inserting into this table, but such is life. I suppose a insert trigger could force this.
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
