Re: Documentation clairification?, CHECK constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Documentation clairification?, CHECK constraints
Date: 2004-03-31 16:53:25
Message-ID: 5872.1080752005@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Karl O. Pinc" <kop(at)meme(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2004-03-31 16:59:38 Re: How can I change type of column
Previous Message Diogo Biazus 2004-03-31 16:52:33 Re: Wich hardware suits best for large full-text indexed