Re: Error Returned by A Function

On Tue, Jan 10, 2006 at 10:42:39AM -0500, Lane Van Ingen wrote:
> select * from current_neighbors(2);
>
> ERROR:  cannot assign non-composite value to a row variable
> CONTEXT:  PL/pgSQL function "current_neighbors" line 15 at assignment

Line 15 of the function is:

>   returnValue := 'none';

You've declared returnValue to be a composite type (typ_remote_net)
so you need to assign to a particular column or use a row constructor:

    returnValue.remote_net := 'none';
    -- or
    returnValue := row('none');

Likewise in a few other places.  Also, the function's query has a
syntax error:

>     order by BY 1,3,2

--
Michael Fuhr