Re: a bug in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <systemguards(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: a bug in plpgsql
Date: 2004-11-04 19:53:09
Message-ID: 28428.1099597989@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jaime Casanova <systemguards(at)yahoo(dot)com> writes:
> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escribi:
>> if/then/else is a statement, not a component of an
>> expression.
>> CASE is an expression construct, not a statement. I
>> think
>> you need to rewrite the CASE as an if/then/elsif
>> statement.

> I will try but this work in v7.4.2 that's why i think
> is an error.

It most certainly did not work in 7.4.2, or any other PG release.
plpgsql doesn't have a CASE statement.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2004-11-04 20:05:22 Re: a bug in plpgsql
Previous Message Jaime Casanova 2004-11-04 19:50:43 Re: a bug in plpgsql