Re: Thoughts on a cosntraint ?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: stan <stanb(at)panix(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Thoughts on a cosntraint ?
Date: 2019-09-29 21:16:50
Message-ID: b8fe02b3-abf9-445f-49f7-af13486590f5@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colin 't Hart 2019-09-29 21:42:00 Redis 16 times faster than Postgres?
Previous Message Rob Sargent 2019-09-29 20:41:57 Re: Thoughts on a cosntraint ?