Re: [BUGS] a bug in plpgsql

2004-11-04 Thread Jaime Casanova
--- 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... an

Re: [BUGS] a bug in plpgsql

2004-11-04 Thread Tom Lane
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

Re: [BUGS] a bug in plpgsql

2004-11-04 Thread Jaime Casanova
--- Tom Lane <[EMAIL PROTECTED]> escribió: > Jaime Casanova <[EMAIL PROTECTED]> writes: > > --- Tom Lane <[EMAIL PROTECTED]> escribió: > >> if/then/else is a statement, not a component of > an > >> expression. > >> CASE is an expression construct, not a statement. > I > >> think > >> you need

Re: [BUGS] a bug in plpgsql

2004-11-04 Thread Tom Lane
Jaime Casanova <[EMAIL PROTECTED]> writes: > --- Tom Lane <[EMAIL PROTECTED]> escribió: >> if/then/else is a statement, not a component of an >> expression. >> CASE is an expression construct, not a statement. I >> think >> you need to rewrite the CASE as an if/then/elsif >> statement. > I will

Re: [BUGS] a bug in plpgsql

2004-11-04 Thread Jaime Casanova
--- Tom Lane <[EMAIL PROTECTED]> escribió: > Jaime Casanova <[EMAIL PROTECTED]> writes: > > CASE rs_dtran.fpg_codigo > > WHEN ''EF'' THEN > > IF rs_ttran.tra_tipo = ''+'' THEN > >

Re: [BUGS] a bug in plpgsql

2004-11-04 Thread Tom Lane
Jaime Casanova <[EMAIL PROTECTED]> writes: > CASE rs_dtran.fpg_codigo > WHEN ''EF'' THEN > IF rs_ttran.tra_tipo = ''+'' THEN > valo