Re: Using a RETURN NEXT - Mailing list pgsql-sql

From Mendola Gaetano
Subject Re: Using a RETURN NEXT
Date
Msg-id 006401c32e79$68424580$10d4a8c0@mm.eutelsat.org
Whole thread Raw
In response to Using a RETURN NEXT  ("Mr Weinbach, Larry" <larryweinbach@yahoo.com>)
Responses Re: Using a RETURN NEXT
List pgsql-sql
From: "Mr Weinbach, Larry" <larryweinbach@yahoo.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










pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Join" on delimeter aggregate query
Next
From: Eivind Kvedalen
Date:
Subject: Re: "Join" on delimeter aggregate query