Re: example of json_to_record(json) not working

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Sébastien DELOBEL <sdelobel(at)hotmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: example of json_to_record(json) not working
Date: 2018-09-03 17:34:59
Message-ID: CAKFQuwbXOSvDMP67=eYhRjCaYcj0oSs0NaqejexXEbTPbH91uQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Monday, September 3, 2018, Sébastien DELOBEL <sdelobel(at)hotmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2018-09-04 06:12:21 Re: BUG #15324: Non-deterministic behaviour from parallelised sub-query
Previous Message Tom Lane 2018-09-03 17:20:29 Re: example of json_to_record(json) not working