Postgres Pro
Downloads
Home   >   mailing lists

Re: example of json_to_record(json) not working - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: example of json_to_record(json) not working
Date
Msg-id CAKFQuwbXOSvDMP67=eYhRjCaYcj0oSs0NaqejexXEbTPbH91uQ@mail.gmail.com
Whole thread Raw
In response to example of json_to_record(json) not working  (Sébastien DELOBEL <sdelobel@hotmail.com>)
List pgsql-bugs
Tree view
On Monday, September 3, 2018, Sébastien DELOBEL <sdelobel@hotmail.com> wrote:

This  

 (123,"a b c")


Is not the same thing as this
 


 {"a": 123, "b": "a b c"}

The record stuff requires a reference type to convert the json stuff too.  The developer is responsible for ensuring a corresponding type or table (implicit type) exists.

David J.
 

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: example of json_to_record(json) not working
Next
From: Amit Kapila
Date:
Subject: Re: BUG #15324: Non-deterministic behaviour from parallelised sub-query