For inputs of a postgis function, I used a cursor to fetch a record at once from a table.
I know that the single record can be printed by the code: FETCH 1 FROM cur1. I wonder how to convert the fetched result into a single string.
BEGIN;
DECLARE cur1 CURSOR FOR SELECT rec FROM Table;
FETCH 1 FROM cur1;
rec
---------------------------------------
vehicles
(1 row)
END;
Thanks!
You can convert row to text just by casting it to text:
BEGIN;
DECLARE cur1 CURSOR FOR SELECT t.*::text FROM Table t;
FETCH 1 FROM cur1;
Row values will be separated by comma and whole row will be enclosed into parenthesis.
If you also want column names it is possible to convert row to JSON:
BEGIN;
DECLARE cur1 CURSOR FOR SELECT row_to_json(t.*) FROM Table t;
FETCH 1 FROM cur1;
DECLARE cur1 CURSOR FOR and you will get a cursor.
string || string