Postgres Pro
Downloads
Home   >   mailing lists

Re: IF statement in Select - Mailing list pgsql-sql

From William Leite Araújo
Subject Re: IF statement in Select
Date
Msg-id bc63ad820604051004t52e47e9bq7bb4bec0d460f4b1@mail.gmail.com
Whole thread Raw
In response to IF statement in Select  (Renato Cramer <renato@domsis.com.br>)
List pgsql-sql
Tree view
     You can use "Case"

     SELECT c1, c2, CASE WHEN c3 = 52 THEN 0 ELSE 1 END AS base_irrf_13 FROM t1;

On 4/5/06, Renato Cramer < renato@domsis.com.br> wrote:
Hello all,

Is the use of IF statement restrict to Functions and Store Procedures?

I'm trying to use an IF within Select...

Example:
create view v1 as
select c1,
c2,
if c3 = 52 then 0
else 1
endif as base_irrf_13
from t1;

Thanks in advance,

Renato Cramer.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



--
William Leite Araújo

pgsql-sql by date:

Previous
From: Renato Cramer
Date:
Subject: IF statement in Select
Next
From: "Marc G. Fournier"
Date:
Subject: Reverse Index ... how to ...