Hi,
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.
Simon.