Re: CASE

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: c k <shreeseva(dot)learning(at)gmail(dot)com>
Cc: Bill Moran <wmoran(at)collaborativefusion(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: CASE
Date: 2008-08-19 12:00:46
Message-ID: 48AAB5EE.10308@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • Re: CASE at 2008-08-19 11:50:25 from c k

Browse pgsql-general by date

  From Date Subject
Next Message Gordon 2008-08-19 12:41:58 Updates and deletes with joins
Previous Message Ow Mun Heng 2008-08-19 11:51:23 Re: What's size of your PostgreSQL Database?