Postgres Pro
Downloads
Home   >   mailing lists

Re: User function that returns a set of rows. - Mailing list pgsql-sql

From Joshua Tolley
Subject Re: User function that returns a set of rows.
Date
Msg-id 4bfafa57.0752640a.0b22.ffff88ac@mx.google.com
Whole thread Raw
In response to User function that returns a set of rows.  (David Harel <hareldvd@gmail.com>)
List pgsql-sql
Tree view 
On Mon, May 24, 2010 at 09:33:35PM +0300, David Harel wrote:
>    When I tried it from the shell I got a nasty error message about that I am
>    not in an environment to receive a set ??? (can't see it now. Office
>    restrictions).
>
>    Any idea?

Your query should say something like "SELECT * FROM select_business_types()".
You'll get that error if you instead say "SELECT select_business_types()".

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

pgsql-sql by date:

Previous
From: David Harel
Date:
Subject: User function that returns a set of rows.
Next
From: Tim Landscheidt
Date:
Subject: Re: safely exchanging primary keys?