Re: Constraint for two fields unique any order

From: MargaretGillon(at)chromalloy(dot)com
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Constraint for two fields unique any order
Date: 2006-07-19 16:42:33
Message-ID: OF86B2D94E.8095AEEF-ON882571B0.005B880A-882571B0.005BC5CF@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Richard and list,

Thanks for the reply. On the constraint what I am trying to create is a
constraint that would not let me create a row with fkey1 = 4 and fkey2 =
10 if I already had a row that had fkey1 = 10 and fkey2 = 4. The
constraint needs to check the combination of values in any order.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2006-07-19 17:08:32 Re: Problem creating a function
Previous Message Eric Faulhaber 2006-07-19 16:33:24 Re: what step need to configure postgres for java application