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 try but this work in v7.4.2 that's why i think > is an error. It most certainly did not work in 7.4.2, or any other PG release. plpgsql doesn't have a CASE statement. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html