Re: Using a RETURN NEXT

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: "Mr Weinbach, Larry" <larryweinbach(at)yahoo(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Using a RETURN NEXT
Date: 2003-06-09 11:22:25
Message-ID: 006401c32e79$68424580$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

From: "Mr Weinbach, Larry" <larryweinbach(at)yahoo(dot)com>

> But at execution time I am getting thi error :
>
> WARNING: Error occurred while executing PL/pgSQL
> function word_case
> WARNING: line 5 at return next
> ERROR: Set-valued function called in context that
> cannot accept a set
>
> I also tried using my own type defined but I got the
> same error.
>
> Any hint or idea will be appreciated ...

I guess that you are calling that function in this way:
#select word_case();

that function is a "table function" so you should use it like a table:

#select * from word_case();

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message James Taylor 2003-06-09 12:00:16 Coalesce/Join/Entries may not exist.
Previous Message Rado Petrik 2003-06-09 09:24:24 Retype