Re: IF function?

On May 1, 2007, at 12:57 AM, David Fetter wrote:

> On Mon, Apr 30, 2007 at 10:51:36PM -0700, novnov wrote:
>>
>> Does postgresql have a built in IF function that allows one to eval a
>> condition and return one or another value? Like:
>>
>> IIF(mybooleanfield = true, "It's true", "It's not true")
>
> It has CASE, as in
>
> CASE foo WHEN true THEN 'It''s true' ELSE 'It''s not true' END;
>

Or, for simple binary conditions like that:

CASE WHEN foo is TRUE
THEN "it's true"
ELSE "it's not true"
END

erik jones <erik(at)myemma(dot)com>
software developer
615-296-0838
emma(r)