Re: plpgsql select into

Поиск
Список
Период
Сортировка
Искать
От
Roger Mason
Тема
Re: plpgsql select into
Дата
Msg-id
y657dggnn9f.fsf@mun.ca
Ответ на
Список
Дерево обсуждения
plpgsql select into Roger Mason <rmason@mun.ca>
Re: plpgsql select into Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql select into Laurenz Albe <laurenz.albe@cybertec.at>
Re: plpgsql select into Roger Mason <rmason@mun.ca>
Re: plpgsql select into Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql select into Roger Mason <rmason@mun.ca>
Re: plpgsql select into "David G. Johnston" <david.g.johnston@gmail.com>
Re: plpgsql select into Roger Mason <rmason@mun.ca>
Hello Tom & Laurenz,

Thanks for your responses.

Laurenz Albe writes:

> Omit "INTO tabular_info" from the query.
> RETURN QUERY already is a destination for the query result.

Yes, if I omit the INTO clause I get data returned.  So then how do I
insert the result of the plpgsql call into a table?  This is what
happens if I try calling 'select into' in psql:

select into info_table from (select get_info('1043_1')) as info_split;
SELECT 1288
test=> select * from info_table ;
--
(1288 rows)

How do I access the data in 'info_table'?

Thanks,
Roger


В списке pgsql-novice по дате отправления
От: Laurenz Albe
Дата:
Сообщение: Re: plpgsql select into
От: Tom Lane
Дата:
Сообщение: Re: plpgsql select into
FAQ