[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Thoughts on a cosntraint ?
From:       Adrian Klaver <adrian.klaver () aklaver ! com>
Date:       2019-09-29 21:16:50
Message-ID: b8fe02b3-abf9-445f-49f7-af13486590f5 () aklaver ! com
[Download RAW message or body]

On 9/29/19 12:40 PM, stan wrote:
> I have a table that consists of 3 columns.
> 
> vendor_key
> mfg_key
> preferred (boolean)
> 
> The idea is that a given vendor is the vendor we want to use for each
> manufacturer for a given project.
> 
> I need to constrain such that  only on row of mfg, vendor and project can
> be set to TRUE.

Where is the project id?

> 
> I would be interested in seeing other peoples approaches on this, also.
> 
> Any thoughts?
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


[prev in list] [next in list] [prev in thread] [next in thread]