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
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@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
In response to "c k" <shreeseva.learning@xxxxxxxxx>:
Personally, I don't understand the question.
> 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.
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@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023
