IronPort-SDR: 
 7bOErAQTXVlaAKXRP3XYtor6vi8uOkdJyGdHXKdB7Qd7wmct8jQMmpZDBhcvyrUOYDZq1br7O0
 oYestMqqT8GyCwfrkG1y8RYu0qbo3vNAqeoDpUoiiXPllPPYj/YTfqYXnpuVWuc42HFzUBi6jz
 Ird3HSbMUCmSbJLwvtgSKC7ZmIjj+LBQ8pndRG/NVcva2QuzE6Owbno06sljFPgSXeAZmix8f0
 dxrTEkcD1dqVAukZWWfyOooTox3aJKbd4ltvdxybwZ5OPBAjJ5P2Wv9pHUEupG+K/MjPDWISxW
 Ibc=
IronPort-HdrOrdr: =?us-ascii?q?A9a23=3ApszwG61X+PrpEMPrgKHwXwqjBK0kLtp133?=
 =?us-ascii?q?Aq2lEZdDV+dMuEm8ey2NQXvCWE6wr5OUtBpTnuAsS9qB/nn6KdgrNxAV7dZm?=
 =?us-ascii?q?bbUQKTRekI0WKI+VHd8kPFmNJg6Q=3D=3D?=
References: <y65a6lco0z4.fsf@mun.ca>
 <6af818d092cf9afb1f7228bca0cbab03ae17bf4d.camel@cybertec.at>
User-agent: mu4e 1.5.6; emacs 27.2
From: Roger Mason <rmason@mun.ca>
Cc: pgsql-novice@postgresql.org
Subject: Re: plpgsql select into
In-reply-to: <6af818d092cf9afb1f7228bca0cbab03ae17bf4d.camel@cybertec.at>
Date: Fri, 20 Aug 2021 13:04:20 -0230
Message-ID: <y657dggnn9f.fsf@mun.ca>
MIME-Version: 1.0
Content-Type: text/plain
Archived-At: <https://www.postgresql.org/message-id/y657dggnn9f.fsf%40mun.ca>
Precedence: bulk

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