From: Erik Wienhold <ewie@ewie.name>
To: Wells Oliver <wells.oliver@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Malformed array literal in goin from jsonb to real[]
Date: Thu, 9 Mar 2023 17:12:57 +0100 (CET)
Message-ID: <59706540.193641.1678378377504@office.mailbox.org> (raw)
In-Reply-To: <84644851.192870.1678377956057@office.mailbox.org>
References: <CAOC+FBWKkoHWmCu+RtkTcJ76FkeqaNTSuPVtzvp=SBK6xbv+kQ@mail.gmail.com>
<84644851.192870.1678377956057@office.mailbox.org>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ewie@ewie.name, wells.oliver@gmail.com
Subject: Re: Malformed array literal in goin from jsonb to real[]
In-Reply-To: <59706540.193641.1678378377504@office.mailbox.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox