Message-ID: <1f660bc35d01cd27112dde5b01ef9b32bab92c16.camel@cybertec.at>
Subject: Re: Return a table from a function
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Simon Connah <simon.n.connah@protonmail.com>,
	"pgsql-novice@lists.postgresql.org"
	 <pgsql-novice@lists.postgresql.org>
Date: Wed, 07 Apr 2021 10:44:08 +0200
In-Reply-To: 
 <b6uFTyH937VOq3XGPT7xAS9Po7-3kwphF834W8eNTl4od008FNoSKn7HPlQnUooaVdk0t1ATa3b6PxJFh3pqF87VTLNJ82VTUXhMkjEqsAs=@protonmail.com>
References: 
	<b6uFTyH937VOq3XGPT7xAS9Po7-3kwphF834W8eNTl4od008FNoSKn7HPlQnUooaVdk0t1ATa3b6PxJFh3pqF87VTLNJ82VTUXhMkjEqsAs=@protonmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/1f660bc35d01cd27112dde5b01ef9b32bab92c16.camel%40cybertec.at>
Precedence: bulk

On Tue, 2021-04-06 at 16:52 +0000, Simon Connah wrote:
> I've written a function that returns a table. It works fine and I get the expected results.
>  The only problem is that in Node.js which is the client the table data is a string rather
>  than a list of variables. Is there some way to change the return data so it is still like
>  a table but in something like JSON? Or even better is there a way to return it as the
>  individual rows so that each column can be easily accessed? I'm using pg-promise to access
>  PostgreSQL from a Node.js web application.

It's a bit unclear what you are doing, but I guess you should run

  SELECT * FROM myfunction('arg');

rather than

  SELECT myfunction('arg');

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com