From: Tom Lane <tgl@sss.pgh.pa.us>
To: Roger Mason <rmason@mun.ca>
cc: pgsql-novice@postgresql.org
Subject: Re: plpgsql select into
In-reply-to: <y657dggnn9f.fsf@mun.ca>
References: <y65a6lco0z4.fsf@mun.ca>
 <6af818d092cf9afb1f7228bca0cbab03ae17bf4d.camel@cybertec.at>
 <y657dggnn9f.fsf@mun.ca>
Comments: In-reply-to Roger Mason <rmason@mun.ca>
	message dated "Fri, 20 Aug 2021 13:04:20 -0230"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1915559.1629475660.1@sss.pgh.pa.us>
Date: Fri, 20 Aug 2021 12:07:40 -0400
Message-ID: <1915560.1629475660@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1915560.1629475660%40sss.pgh.pa.us>
Precedence: bulk

Roger Mason <rmason@mun.ca> writes:
> 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)

You selected zero columns (which psql is not very good at displaying :-().
Try

select * into info_table from (select get_info('1043_1')) as info_split;

BTW, that could be simplified a lot:

select * into info_table from get_info('1043_1');

			regards, tom lane