Is there a way to write a function in

plpgsql

which returns heterogeneous data? I've tried using

plv8

for this but

plv8

modifies nested arrays which ruins my data structure for the front-end (e.g., it turns

[['a', 'b', 'c'], ['d', 'e', 'f']]

into

['a', 'b', 'c', 'd', 'e', 'f']

).

Hello @Albert [tox/cis]! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Well, I've solved it using

to_json

on the field which will prevent plv8 from concatenating the nested arrays

Thread was archived by @Albert [tox/cis]. Anyone can send a message to unarchive it.