Re: CASE

In response to "c k" <shreeseva.learning@gmail.com>:

> 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.

Personally, I don't understand the question.

Perhaps if you provided an example of what you are trying to do with
CASE WHEN and why it doesn't work for you.

It _does_ sound like you need to be using something like pl/pgsql.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023