--- Tom Lane <__> wrote: > "Riccardo G. Facchini" <__> writes: > > declare my_new_complex complex_number; > > > select * from complex_to_complex(my_new_complex) into my_result; > > > ERROR: column "my_new_complex" does not exist > > plpgsql doesn't presently cope with passing whole-row variables into > SQL > expressions, which is essentially what you've got here. There's some > chance it will work in time for 7.5. > > regards, tom lane
then, why --- select * from complex_to_real(real_to_complex(1, 2)); select * from complex_to_complex(real_to_complex(1, 2)); --- work? and why the function definition: CREATE or replace FUNCTION public.really_really_complex(complex_number) RETURNS complex_number AS 'declare my_complex alias for $1; declare my_result complex_number; begin my_result := complex_to_complex(my_complex); return my_result; end;' LANGUAGE 'plpgsql' VOLATILE; --- doesn't make a difference? thanks for your quick answer, ===== Riccardo G. Facchini ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
