Re: [GENERAL] Fwd: row_to_json() with numerical indices in stead of associative indices

2013-12-01 Thread Tjibbe
I had tried something similar, but it is not possible because: ERROR: PL/pgSQL functions cannot accept type record So it would be nice that in version postgresql 9.4 this parameter is added to the function row_to_json. Maybe RECORD as INPUT parameter is allowed in other procedural languages lik

Re: [GENERAL] Fwd: row_to_json() with numerical indices in stead of associative indices

2013-11-30 Thread Michael Paquier
On Sat, Nov 30, 2013 at 11:48 PM, Tjibbe wrote: > Hello there, > > Is it possible to add an parameter for the function row_to_json()? So > you can choose for: > > numerical indices: [1, true, "string", null] > associative indices: ["f1":1,"f2": true, "f3":"string","f4": null] > > The this extra

[GENERAL] Fwd: row_to_json() with numerical indices in stead of associative indices

2013-11-30 Thread Tjibbe
Hello there, Is it possible to add an parameter for the function row_to_json()? So you can choose for: numerical indices: [1, true, "string", null] associative indices: ["f1":1,"f2": true, "f3":"string","f4": null] The this extra parameter can save bandwidth between the webserver(postgresql/p