Re: plpgsql return setof integer?

Поиск
Список
Период
Сортировка
От Christopher Murtagh
Тема Re: plpgsql return setof integer?
Дата
Msg-id 1068679392.2960.1.camel@mafalda.murtagh.name
обсуждение исходный текст
Список pgsql-general
On Wed, 2003-11-12 at 17:35, Christopher Murtagh wrote:
>  I've got a fairly simple function that I'm trying to return a set, but
> seem to have come across a stumbling block. When I execute the function
> below (the input params are not used at the moment) I get this:
>
> chris=# select htdig('foo', 'foo');

Actually, I just found my problem. I changed the above query to:

chris=# select * from htdig('foo', 'foo');

and it works as expected. Thanks again to everyone on this list who
helped out.

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax:  (514) 398-2017

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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: serial type vs. sequences
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SQL-question: returning the id of an insert querry