[GENERAL] Set returning functions and Crystal Reports

[Josué Maldonado]

Hello list,
Apologize first if this is off topic.
have this function in plpgsql
DECLARE
        crow histmer%rowtype;
BEGIN
        select * into crow from histmer
        where fecha = date 'now';
        if found then
                return next crow;
        end if;
        select * into crow from histmer order by fecha desc limit 1 ;
        insert into histmer values (date 'now', crow.mercado_ne, crow.factor_adu) ;
        select * into crow from histmer
                where fecha = date 'now';
                
return;
END
Any idea to make Crystal Reports (10) to accept it as a data set resulting?
Thanks in advace
--
Sinceramente,
Josué Maldonado.
"Para todo mal existen dos remedios: el tiempo y el silencio." Alejandro 
Dumas. Escritor francés.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly