case stement when null - Mailing list pgsql-sql

hi all,

Well i rethink my design 'cause the other was too slow. but all solutions 
involves new problems... now my problem is with a function of this type:


CREATE OR REPLACE FUNCTION "public"."rec_f_consultarplanificacionrubros" 
(smallint, smallint, char(9), smallint, smallint, smallint, char(2)) RETURNS 
SETOF "public"."rec_td_rubrosplanificados" AS '   select rub_codigo, cpa_valor, cpa_fechavencimiento        from
rec_m_cuadropagosciclo   where ent_codigo = $1      and sec_codigo = $2      and ani_codigo = $3      and case $4
          when null then cic_codigo IN (select cic_codigo from 
 
aca_m_cicloaniolectivo                                                       where ent_codigo = 
$1                                                         and sec_codigo = 
$2                                                         and ani_codigo = 
$3)                  else cic_codigo = $4             end
' LANGUAGE 'sql'

but when $4 is null the function executes the else part and what i want to 
do is to execute the when null. Can you help me???


Thanx in advance,

Jaime Casanova

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail