--- Tom Lane <[EMAIL PROTECTED]> escribió: > Jaime Casanova <[EMAIL PROTECTED]> writes: > > --- Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])