Re: IF function?

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;

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate