Tuesday, August 19, 2008

Re: [GENERAL] CASE

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: