test strange behavior

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: test strange behavior
Date: 2011-11-06 20:57:39
Message-ID: 20111106215739.3d270fd1@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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).

Any clue?

JY
--
If men could get pregnant, abortion would be a sacrament.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2011-11-06 21:47:56 Re: extension installation PB
Previous Message Devrim GÜNDÜZ 2011-11-06 19:04:52 Re: extension installation PB