Re: test strange behavior

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: test strange behavior
Date: 2011-11-06 21:55:04
Message-ID: 8279.1320616504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Jean-Yves F. Barbier" <12ukwn(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2011-11-06 23:50:29 Re: test strange behavior
Previous Message Tom Lane 2011-11-06 21:47:56 Re: extension installation PB