We are developing a JSON payload to be passed via a web service to an IOS application. It is simple enough to use the FOR JSON AUTO clause and I have obtained a variety of JSON selects. But our iPad developers have asked for a combined payload that would concatenate several selects into a single long varchar.

Thanks for the ideas, looks like I will just "string" the data together. (Glad JSON is rather simple in that regard.)

The basic SELECT... FOR JSON is so easy, I was hoping for one more silver bullet:
- SELECT * FROM A FOR JSON INTO ls_jsona;
- SELECT * FROM B FOR JSON INTO ls_jsonb;
- SELECT ls_jsona || ls_jsonb;
OR:
- SELECT * FROM A FOR JSON UNION ALL SELECT * FROM B FOR JSON;