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