Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: CHECK clause doesn't work with CASE clause
Date
Msg-id 25000.1025185453@sss.pgh.pa.us
Whole thread Raw
In response to CHECK clause doesn't work with CASE clause  ("Jörg Holetschek" <mail2holly@gmx.de>)
List pgsql-sql
Tree view 
"J�rg Holetschek" <mail2holly@gmx.de> writes:
>                   CASE
>                      WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE

Try "focus IS NOT NULL".
        regards, tom lane

pgsql-sql by date:

Previous
From: "Jörg Holetschek"
Date:
Subject: CHECK clause doesn't work with CASE clause
Next
From: Masaru Sugawara
Date:
Subject: Re: 2 Selects 1 is faster, why?