| From: | Jitendra Loyal <jitendra(dot)loyal(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Check constraints do not seem to be working!!! |
| Date: | 2020-11-11 18:16:20 |
| Message-ID: | CAGBkuscBAWhR6SuJqKWTKO1dhLetYuKrmK=ttN0KXDe-JugJpw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks Laurenz
This is interesting...b is True
Thanks and regards,
Jitendra
On Wed 11 Nov, 2020, 22:52 Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2020-11-11 22:03:50 | Re: New "function tables" in V13 documentation |
| Previous Message | Laurenz Albe | 2020-11-11 17:22:21 | Re: Check constraints do not seem to be working!!! |