Re: a bug in plpgsql

Jaime Casanova <systemguards@yahoo.com> writes:
>  --- Tom Lane <tgl@sss.pgh.pa.us> escribió:
>> It most certainly did not work in 7.4.2, or any
>> other PG release.
>> plpgsql doesn't have a CASE statement.

> This is a production server... and the same script...
> (It was an error in v7.4.2 to permit this?)

Are you sure the function has ever been executed?  7.4 gives me

regression=# select recaudaciones.rec_f_aperturarcaja(1::int2,2::int2);
ERROR:  syntax error at or near "ELSE"
CONTEXT:  compile of PL/pgSQL function "rec_f_aperturarcaja" near line 51

8.0 is just reporting the error when the function is defined instead
of at first call.

            regards, tom lane