Date: Thu, 9 Mar 2023 17:12:57 +0100 (CET)
From: Erik Wienhold <ewie@ewie.name>
To: Wells Oliver <wells.oliver@gmail.com>,
	pgsql-admin <pgsql-admin@postgresql.org>
Message-ID: <59706540.193641.1678378377504@office.mailbox.org>
In-Reply-To: <84644851.192870.1678377956057@office.mailbox.org>
References: 
 <CAOC+FBWKkoHWmCu+RtkTcJ76FkeqaNTSuPVtzvp=SBK6xbv+kQ@mail.gmail.com>
 <84644851.192870.1678377956057@office.mailbox.org>
Subject: Re: Malformed array literal in goin from jsonb to real[]
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Importance: Normal
Archived-At: 
 <https://www.postgresql.org/message-id/59706540.193641.1678378377504%40office.mailbox.org>
Precedence: bulk

> On 09/03/2023 17:05 CET Erik Wienhold <ewie@ewie.name> wrote:
>
> Use jsonb_populate_record with a custom type:
>
> 	create type myrec as (col real[][]);
> 	
> 	select * from jsonb_populate_record(null::myrec, '{"col":[[0,1],[2,3]]}');
> 	
> 	      col
> 	---------------
> 	 {{0,1},{2,3}}
> 	(1 row)

I just noticed that it's also possible without a custom type:

	select * from jsonb_to_record('{"col":[[0,1],[2,3]]}') as t(col real[]);

--
Erik