Re: [SQL] CASE

You need v6.5beta, previous releases haven't this feature:

SELECT *, CASE
WHEN COLUMN1 = 1
THEN 'A'
WHEN COLUMN1 = 2
THEN 'B'
ELSE 'C'
END FROM TABLE2;
column1|case
-------+----
1|A
2|B
3|C
4|C
(4 rows)

José

vernichon eric ha scritto:

> Hello ,
>
> I want transfered query from sql serveur to postgres but i
> don't know how use CASE with postgres
>
> Thank you
>
> Eric Vernichon

--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'