Re: Needed function IF(expr, expr, expr)

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Marek Lewczuk <newsy(at)lewczuk(dot)com>
Cc: Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Needed function IF(expr, expr, expr)
Date: 2003-09-06 15:43:38
Message-ID: 20030906154338.GB24418@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Sat, Sep 06, 2003 at 14:55:12 +0100,
Marek Lewczuk <newsy(at)lewczuk(dot)com> wrote:
> Hello,
> I'm moving out from MySQL to PostgreSQL and there are some function
> which are not supported in PG so I'm trying to write my own functions.
> Currently I have big problem with function IF(), below the description
> of this function from MySQL manual.

You should be able to do what you want using CASE instead of IF.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2003-09-06 16:32:24 Re: Needed function IF(expr, expr, expr)
Previous Message Peter Eisentraut 2003-09-06 14:05:28 Re: Needed function IF(expr, expr, expr)

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Eckermann 2003-09-06 16:32:24 Re: Needed function IF(expr, expr, expr)
Previous Message Robert Treat 2003-09-06 14:41:47 Re: Notices for redundant operations