Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Check constraints do not seem to be working!!!
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Wed, 11 Nov 2020 18:22:21 +0100
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <698d0c84-ff8a-4197-51d4-0a9772b998dd@enterprisedb.com>
References: <CAGBkusdqR7ZuovjZmqCwN913=PRCTmnUjT3KdEyXCr3z74BNoQ@mail.gmail.com> <CANNMO+L_8KePx6Svj2kFOd1RHnWZTMy7_-KXq+sJDHLM8gPinw@mail.gmail.com> <CAGBkuscy+YehMzqAmhijQrQ37yhDAMSaWQ+rJJMmA1zWN_3ZaA@mail.gmail.com> <698d0c84-ff8a-4197-51d4-0a9772b998dd@enterprisedb.com>
User-agent: Evolution 3.36.5 (3.36.5-1.fc32)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Check constraints do not seem to be working!!!
  - From: Jitendra Loyal

References:
- Check constraints do not seem to be working!!!
  - From: Jitendra Loyal
- Re: Check constraints do not seem to be working!!!
  - From: Nikolay Samokhvalov
- Re: Check constraints do not seem to be working!!!
  - From: Jitendra Loyal
- Re: Check constraints do not seem to be working!!!
  - From: Tomas Vondra

Prev by Date: Re: Execution plan does not use index
Next by Date: Re: Check constraints do not seem to be working!!!
Previous by thread: Re: Check constraints do not seem to be working!!!
Next by thread: Re: Check constraints do not seem to be working!!!
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]