Re: User function that returns a set of rows.

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: David Harel <hareldvd(at)gmail(dot)com>
Cc: postgres sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: User function that returns a set of rows.
Date: 2010-05-24 22:14:45
Message-ID: 4bfafa57.0752640a.0b22.ffff88ac@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Landscheidt 2010-05-25 01:22:46 Re: safely exchanging primary keys?
Previous Message David Harel 2010-05-24 18:33:35 User function that returns a set of rows.