Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group