Re: IF function?

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: novnov <novnovice(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: IF function?
Date: 2007-05-01 05:59:16
Message-ID: d86a77ef0704302259qb8ea1dcv985e02552e180d1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

IF ( condition here)
-- to do
ELSE
-- to
END IF

On 5/1/07, novnov <novnovice(at)gmail(dot)com> 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")
>
>
> --
> View this message in context:
> http://www.nabble.com/IF-function--tf3673523.html#a10264910
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Lambert 2007-05-01 07:24:31 PG Books
Previous Message David Fetter 2007-05-01 05:57:31 Re: IF function?