Re: Function Returning SETOF Problem - Mailing list pgsql-general

From Joe Conway
Subject Re: Function Returning SETOF Problem
Date
Msg-id 3FE1DED6.2090208@joeconway.com
Whole thread Raw
In response to Re: Function Returning SETOF Problem  (Ron St-Pierre <rstpierre@syscor.com>)
List pgsql-general
Ron St-Pierre wrote:
> Here are my record type and function:

Note -- you could make it easier for people to help, and hence increase
your chances of getting help, if your sample code is complete. I.e.
provide the needed table definition(s) and even some sample data (INSERT
statements) so we don't have to reverse engineer those things.

>           END LOOP;
>           RETURN 1;
>       END;
>   ' LANGUAGE 'plpgsql';

The line "RETURN 1;" ought to be just "RETURN;"

HTH,

Joe


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Function Returning SETOF Problem
Next
From: Peter Eisentraut
Date:
Subject: Re: restore error - language "plperlu" is not trusted