On Thursday 27 Jun 2002 10:52 am, Jörg Holetschek wrote:
> Hi folks,
>
> I have a problem with a CHECK clause that doesn't seem to work properly.
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> WHEN ((focus <> NULL) AND (epilepsy_class IN ('g',
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
"Jörg Holetschek" <[EMAIL PROTECTED]> writes:
> CASE
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE
Try "focus IS NOT NULL".
regards, tom lane
---(end of broadcast)-
Hi folks,
I have a problem with a CHECK clause that doesn't seem to work properly. The
CREATE TABLE statement looks like this:
CREATE TABLE epilepsy_information (
[...]
epilepsy_class Char
CHECK (epilepsy_class IN ('f', 'g', 'n')),
focusInteg
