Home > mailing lists

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

From	Patrick B
Subject	[GENERAL] Constraint + where
Date	March 20, 2017 06:16:08
Msg-id	CAJNY3iu8nWxcKG=Xfjeo9ap8n=TfcnESadmBHO8jY4QMiCDVKw@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] Constraint + where (Melvin Davidson <melvin6925@gmail.com>)
List	pgsql-general

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!

From: Sylvain Marechal
Date: 20 March 2017, 01:04:07
Subject: Re: [GENERAL] Best way to alter a foreign constraint

From: Melvin Davidson
Date: 20 March 2017, 06:27:11
Subject: Re: [GENERAL] Constraint + where