Re: test strange behavior - Mailing list pgsql-novice

From Tom Lane
Subject Re: test strange behavior
Date
Msg-id 8279.1320616504@sss.pgh.pa.us
Whole thread Raw
In response to test strange behavior  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-novice
"Jean-Yves F. Barbier" <12ukwn@gmail.com> writes:
> Hi list,
> I've a function that test a boolean parm, as:
> ....
> CASE $3
> WHEN TRUE THEN
>     blabla
> WHEN FALSE THEN
>     proutprout
> ELSE
>     gadugadu
> END CASE;
> ....

> AFAI understand, the ELSE case would normally be triggered with a NULL
> but it isn't ('WHEN NULL THEN' also don't work).

Works for me ... maybe you need to show a more complete example,
so that we can see where the problem really is?

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: extension installation PB
Next
From: Tom Lane
Date:
Subject: Re: test strange behavior