Re: a bug in plpgsql

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escribió:
> Jaime Casanova <systemguards(at)yahoo(dot)com> writes:
> > CASE rs_dtran.fpg_codigo
> > WHEN ''EF'' THEN
> > IF rs_ttran.tra_tipo = ''+'' THEN
> > valor_ef := valor_ef + rs_dtran.dtr_valor;
> > ELSE
> > valor_ef := valor_ef - rs_dtran.dtr_valor;
> > END IF;
> > WHEN ''CH'' THEN
> > IF rs_ttran.tra_tipo = ''+'' THEN
> > valor_ch := valor_ch + rs_dtran.dtr_valor;
> > ELSE
> > valor_ch := valor_ch - rs_dtran.dtr_valor;
> > END IF;
> > END;
>
> > but in that line there is a valid IF .. THEN ..
> ELSE
> > block.
>
> 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.
>
> regards, tom lane
>

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

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com