--- Tom Lane <tgl@sss.pgh.pa.us> escribió:
> 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.
>
Ok, you are right. I was sure i have ran this but
maybe i ran one older.
sorry for the trouble.
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