Re: Function Returning SETOF Problem

From: Joe Conway <mail(at)joeconway(dot)com>
To: Ron St-Pierre <rstpierre(at)syscor(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Function Returning SETOF Problem
Date: 2003-12-18 17:07:34
Message-ID: 3FE1DED6.2090208@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-18 17:38:18 Re: restore error - language "plperlu" is not trusted
Previous Message Stephan Szabo 2003-12-18 17:03:52 Re: Function Returning SETOF Problem