Hello Develop PL/pgSQL (PostgreSQL 8.4) has CASE statement. Actual and older version hasn't nothing similar. Regards Pavel Stehule 2008/8/19 c k <shreeseva.learning@xxxxxxxxx>: > Is there any control structure statement similar to select case ... ? If yes > how to use it. I have tried to use, case when <expression> then <expression> > end, but not worked well as I want to use other control structures and sql > statements to be executed for each case. > > Please reply. > Thanks > CPK. >