--- Tom Lane <tgl@sss.pgh.pa.us> escribió:
> Jaime Casanova <systemguards@yahoo.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
