Re: User function that returns a set of rows.

Поиск
Список
Период
Сортировка
От Joshua Tolley
Тема Re: User function that returns a set of rows.
Дата
Msg-id 4bfafa57.0752640a.0b22.ffff88ac@mx.google.com
обсуждение исходный текст
Ответ на User function that returns a set of rows.  (David Harel <hareldvd@gmail.com>)
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: David Harel
Дата:
Сообщение: User function that returns a set of rows.
Следующее
От: Tim Landscheidt
Дата:
Сообщение: Re: safely exchanging primary keys?