Postgres Pro
Downloads
Home   >   mailing lists

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

From Jitendra Loyal
Subject Re: Check constraints do not seem to be working!!!
Date
Msg-id CAGBkuscBAWhR6SuJqKWTKO1dhLetYuKrmK=ttN0KXDe-JugJpw@mail.gmail.com
Whole thread Raw
In response to Re: Check constraints do not seem to be working!!!  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
Thanks Laurenz

This is interesting...b is True

Thanks and regards,
Jitendra

On Wed 11 Nov, 2020, 22:52 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
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: Laurenz Albe
Date:
Subject: Re: Check constraints do not seem to be working!!!
Next
From: Bruce Momjian
Date:
Subject: Re: New "function tables" in V13 documentation