Re: a bug in plpgsql - Mailing list pgsql-bugs

From Tom Lane
Subject Re: a bug in plpgsql
Date
Msg-id 29373.1099600105@sss.pgh.pa.us
Whole thread Raw
In response to Re: a bug in plpgsql  (Jaime Casanova <systemguards@yahoo.com>)
Responses Re: a bug in plpgsql
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: a bug in plpgsql
Next
From: Jaime Casanova
Date:
Subject: Re: a bug in plpgsql