Postgres Pro
Downloads
Home   >   mailing lists

Re: Documentation clairification?, CHECK constraints - Mailing list pgsql-general

From Tom Lane
Subject Re: Documentation clairification?, CHECK constraints
Date
Msg-id 5872.1080752005@sss.pgh.pa.us
Whole thread Raw
In response to Documentation clairification?, CHECK constraints  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: Documentation clairification?, CHECK constraints
List pgsql-general
Tree view 
"Karl O. Pinc" <kop@meme.com> writes:
> But SQL has 3 valued logic (strictly speaking, not boolean).  It
> seems that the CHECK clases fail only when the expression result
> is FALSE, and pass when the result is either TRUE or UNKNOWN.

Correct --- this is per spec.

> Yes?  Should this be clarified in the documentation?

Sure, send a documentation patch.

            regards, tom lane

pgsql-general by date:

Previous
From: Diogo Biazus
Date:
Subject: Re: Wich hardware suits best for large full-text indexed
Next
From: Steve Atkins
Date:
Subject: Re: select statement sorting