Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraint for two fields unique any order - Mailing list pgsql-general

From MargaretGillon@chromalloy.com
Subject Re: Constraint for two fields unique any order
Date
Msg-id OF86B2D94E.8095AEEF-ON882571B0.005B880A-882571B0.005BC5CF@CHROMALLOY.COM
Whole thread Raw
In response to Constraint for two fields unique any order  (MargaretGillon@chromalloy.com)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Eric Faulhaber
Date:
Subject: Re: what step need to configure postgres for java application
Next
From: Cornelia Boenigk
Date:
Subject: Problem creating a function