cant get what I want from array_to_json (simple)

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: cant get what I want from array_to_json (simple)
Date: 2015-12-16 21:23:59
Message-ID: CACpWLjOpxfWyJOOPZ6uDYMvfVWYzfZrhdHuoqXTACbWJd04B_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

CREATE TYPE key_value_pair AS
(key text,
value text);

DO $$declare
arr qsn_app.key_value_pair[];
pcolumn_values_i json;
begin
arr[0] := ('this','that');
arr[1] := ('another','one');
pcolumn_values_i := array_to_json( arr );
RAISE NOTICE '#1 %', pcolumn_values_i;
end$$;

the 'NOTICE' shows:
NOTICE: #1 [{"key":"this","value":"that"},{"key":"another","value":"one"}]
what I want to see is:
NOTICE: #1 {"this":"that","another":"one"}

TIA,
Mike

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2015-12-16 21:42:13 Re: cant get what I want from array_to_json (simple)
Previous Message Michael Moore 2015-12-15 21:01:33 Re: Name/Value array to table row