Postgres Pro
Downloads
Home   >   mailing lists

Re: Check constraints do not seem to be working!!! - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Check constraints do not seem to be working!!!
Date
Msg-id b7652529f4403052c343184ec918b76d1f018c57.camel@cybertec.at
Whole thread Raw
In response to Re: Check constraints do not seem to be working!!!  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: Check constraints do not seem to be working!!!  (Jitendra Loyal <jitendra.loyal@gmail.com>)
List pgsql-general
Tree view 
On Wed, 2020-11-11 at 11:47 +0100, Tomas Vondra wrote:
> you may do this, for example:
> 
>     (b it not null and b = true) and (c is not null)
> 
> Or something like that.

My (equivalent) suggestion:

   b IS TRUE AND c IS NOT NULL

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-general by date:

Previous
From: Peter Coppens
Date:
Subject: Re: Execution plan does not use index
Next
From: Jitendra Loyal
Date:
Subject: Re: Check constraints do not seem to be working!!!