Re: function with a composite type calling another function - Mission Impossible?

"Riccardo G. Facchini" <abief_ag_-postgresql@yahoo.com> 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