Re: CASE

Hi,
I want to create a function as follows:

case variable=value1
SQL statements
case variable=value2
SQL statements
case else
end of case

CPK

On Tue, Aug 19, 2008 at 5:17 PM, Bill Moran
<wmoran(at)collaborativefusion(dot)com>wrote:

> In response to "c k" <shreeseva(dot)learning(at)gmail(dot)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/<http://people.collaborativefusion.com/%7Ewmoran/>
>
> wmoran(at)collaborativefusion(dot)com
> Phone: 412-422-3463x4023
>