Re: Check constraints do not seem to be working!!!

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Jitendra Loyal <jitendra(dot)loyal(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Check constraints do not seem to be working!!!
Date: 2020-11-11 17:22:21
Message-ID: b7652529f4403052c343184ec918b76d1f018c57.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jitendra Loyal 2020-11-11 18:16:20 Re: Check constraints do not seem to be working!!!
Previous Message Peter Coppens 2020-11-11 14:45:35 Re: Execution plan does not use index