Re: Trouble returning setof - Mailing list pgsql-general

From Joe Conway
Subject Re: Trouble returning setof
Date
Msg-id 3EE7B48B.3080708@joeconway.com
Whole thread Raw
In response to Trouble returning setof  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
Rory Campbell-Lange wrote:
> ERROR:  Set-valued function called in context that cannot accept a set
>


Make sure you are doing:

   select * from fn_v1a_board_view_items();
          ^^^^^^^

*not*

   select fn_v1a_board_view_items();

HTH,

Joe


pgsql-general by date:

Previous
From: Ron Snyder
Date:
Subject: Re: error restoring large objects during pg_restore (re
Next
From: Travis Hume
Date:
Subject: need a method to ping a running database