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 <[EMAIL PROTECTED]>wrote: > In response to "c k" <[EMAIL PROTECTED]>: > > > 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/> > > [EMAIL PROTECTED] > Phone: 412-422-3463x4023 >
