Thread: CASE
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.
Please reply.
Thanks
CPK.
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@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. > > Please reply. > Thanks > CPK. >
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
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@collaborativefusion.com> wrote:
In response to "c k" <shreeseva.learning@gmail.com>: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@collaborativefusion.com
Phone: 412-422-3463x4023
c k wrote: > Hi, > I want to create a function as follows: > > case variable=value1 > SQL statements > case variable=value2 > SQL statements > case else > end of case > Looks like you want to use pl/pgsl and IF ... THEN ... ELSE instead? Cheers Tino