On Mon, 10 May 2004, Ivan Sergio Borgonovo wrote: > Now let's come to the problem: > > create or replace function testa( ) > returns char(32) as > ' > begin > if 1=2 then > if 1=2 then > select 1; > elseif 1=3 then > select 2; > elseif 1=4 then Don't you mean ELSIF, not ELSEIF? Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match