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 like PL/phyton.
On 1 December 2013 06:43, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:
You could rename your function to_num_json to row_to_json and trickOn Sat, Nov 30, 2013 at 11:48 PM, Tjibbe <tjibbe@xxxxxxxxxx> 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 parameter can save bandwidth between the
> webserver(postgresql/php) and client(_javascript_).
>
> Now i'm doing it like this:
>
> CREATE FUNCTION to_num_json(_in json) RETURNS json AS $$
> DECLARE
> _pair RECORD;
> _arr json[];
> BEGIN
> FOR _pair IN SELECT * FROM json_each(_in) LOOP
> _arr := _arr || _pair.value;
> END LOOP;
> RETURN to_json(_arr);
> END
> $$ language plpgsql;
>
> SELECT to_num_json(
> row_to_json((5, TRUE, 'string', NULL))
> );
search_path to include it in your client depending on the schema where
the new function is as two functions with the same name but different
arguments can live together. IMO, you are right to do that with
plpgsql and json_each.
Regards,
--
Michael
