Just a simple question.
It's known that in SQL field = NULL is diferrent from from field IS NULL.
Does the same rule applies when you use CASE .. WHEN statement ?
WHEN IS NULL THEN....
From my tests, shows this sintaxt is incorrect so I replaced to
WHEN NULL THEN ...
this 2nd example worked so far, but I'm worried about that isn't correct way
of doing it and may generate some failure returning rows with inconsistent
So, you guys know if using this way is a valid CASE/WHEN sentence?
I know also there's
WHEN myField IS NULL THEN ...
but I'm asking about the 2nd way to make it clear to me.
pgsql-novice by date
|Next:||From: brucejhyatt||Date: 2009-06-11 00:34:28|
|Subject: Re: Yum Update Errors|
|Previous:||From: Merlin Moncure||Date: 2009-06-09 14:34:27|
|Subject: Re: Why lots of temp schemas are being created|