Re: CHECK clause doesn't work with CASE clause - Mailing list pgsql-sql

On Thu, Jun 27, 2002 at 11:52:54AM +0200, J?rg Holetschek wrote:
> Hi folks,
> 
> I have a problem with a CHECK clause that doesn't seem to work properly. The

>                   CASE
>                      WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE
>                      WHEN ((focus <> NULL) AND (epilepsy_class IN ('g',
> 'n'))) THEN FALSE
>                   END),

The condition "focus <> NULL" can't ever come out true. You probably
mean IS NOT NULL.

Richard