Re: SRF written in C

El mié, 02-07-2008 a las 08:02 +0200, Martijn van Oosterhout escribió:
> On Tue, Jul 01, 2008 at 10:02:39AM -0500, Felipe de Jesús Molina Bravo wrote:
> > Hi
> >
> > what can i do for  a SRF written in C, can called as follow:
> >
> >   select * from obtAscendencia('(11099,15685)','(6808,9621)');
> >
> > I can call the function:
> >   select obtAscendencia('(11099,15685)','(6808,9621)');
>
> I'm afraid you did not explain what exactly the problem is. Do you mean
> that one or the other of the statements doesn't work? Which one, and
> what is the error message?
>
> Have a nice day,

ok... sorry

the next statement:
   select * from obtAscendencia('(11099,15685)','(6808,9621)');

never end .... i need to kill the process assigned for my statement...
and  the other statement:

   select obtAscendencia('(11099,15685)','(6808,9621)');

is  correct ... the output is:

 obtascendencia
----------------
 (4291, 6064)
 (1774, 2507)
 (1031, 1457)
 (288, 407)
 (121, 171)
 (75, 106)
 (29, 41)
 (12, 17)
 (7, 10)
 (2, 3)
(10 filas)

and my question is :

Why can not perform my function as the first statement?

I suspect that my error is:

        r = obtPadre( &intF->izq, &intF->der );
        if (  ( r->num != 1 ) &&
              ( r->den != 2 )   )
            {

                intF->der.num = intF->izq.num;
                intF->der.den = intF->izq.den;
                intF->izq.num = r->num;
                intF->izq.den = r->den;

                SRF_RETURN_NEXT(funcctx, (Datum)(r));
            }

Where "r" is type "Racional" (Rational)...



thanks in advance

see you