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:
> > --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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