Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Constraint + where - Mailing list pgsql-general

From Melvin Davidson
Subject Re: [GENERAL] Constraint + where
Date
Msg-id CANu8Fiw2YzM1aAkMjV2iyZ3HurXVsvjJ5nVm1APHME2ZUYesCQ@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Constraint + where  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: [GENERAL] Constraint + where  (Patrick B <patrickbakerbr@gmail.com>)
Re: [GENERAL] Constraint + where  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view


On Sun, Mar 19, 2017 at 8:16 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
Hi guys,

I've got a column 'type_note' on a new table that it's being designed:

type_note varchar(32) NOT NULL;

On that column, there will be three different data:

1. yes
2. no
3. maybe

I wanna create a FK but just when the data on that column is = maybe.

How can I do that? Thanks!


Why just "maybe"? Since there can only be three valid answers, why not FK for all three?

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: [GENERAL] Constraint + where
Next
From: Patrick B
Date:
Subject: Re: [GENERAL] Constraint + where