Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mHPq0-0006Dd-4J for pgsql-novice@arkaria.postgresql.org; Sat, 21 Aug 2021 12:11:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mHPpx-0003oG-CC for pgsql-novice@arkaria.postgresql.org; Sat, 21 Aug 2021 12:10:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mHOcD-0004az-3q for pgsql-novice@lists.postgresql.org; Sat, 21 Aug 2021 10:52:41 +0000 Received: from esa05.ucs.mun.ca ([134.153.136.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mHOc8-0008KD-9f for pgsql-novice@postgresql.org; Sat, 21 Aug 2021 10:52:38 +0000 IronPort-SDR: IhRr/ewoNPULVYnzVkAqeSz9UDdRzi88sfMiTObEbWB6k/3RwTy0Ds8moImMqKksRSxDQ4L+Ks vS+ZykpqZin/5E1B7eK/4TcFYvS/u9rvKe5VPOmZYItCGu1FNfQVzJw9FipJ5EMxM3antRKExy 4xxxFou0PFgxFLe1ZY5rAcKkb96EiZE3024KPzAH4V28lDgXut7Cczf2ogvPApimK8JlZo2Ied X6ePt4iA5++Xya6jINCVgMR8UlcNvJaHVgl4vVM3TImiSeWLkaV75Or3E7jg9LLSKPlIEGNFVK z2c= IronPort-HdrOrdr: =?us-ascii?q?A9a23=3ABqz6Z6z2PYLP95QWqduoKrPwKL1zdoMgy1?= =?us-ascii?q?knxilNoH1uA66lfq+V/cjzuSWYtB8wXzU6lcmEKO2cRxrnm6KdgrNhXotKPj?= =?us-ascii?q?OHhILAFugL0WKh+Vbd8kbFmdK1u50NT4FDEtHqSVB1gcHmiTPTL+od?= X-IronPort-AV: E=Sophos;i="5.84,340,1620700200"; d="scan'208";a="58670775" X-Amp-Result: SKIPPED(no attachment in message) X-Amp-File-Uploaded: False Received: from cpe00fc8db7a323-cm00fc8db7a320.cpe.net.cable.rogers.com (HELO pyrope.local) ([174.117.202.255]) by smtp05.ucs.mun.ca with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 21 Aug 2021 08:22:30 -0330 References: <6af818d092cf9afb1f7228bca0cbab03ae17bf4d.camel@cybertec.at> <1915560.1629475660@sss.pgh.pa.us> User-agent: mu4e 1.5.6; emacs 27.2 From: Roger Mason To: pgsql-novice@postgresql.org Subject: Re: plpgsql select into In-reply-to: <1915560.1629475660@sss.pgh.pa.us> Date: Sat, 21 Aug 2021 08:22:28 -0230 Message-ID: MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tom Lane writes: > Roger Mason writes: > 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'); Embarassed cough :-). And thanks for the simplification. Roger