Table 9-40. json and jsonb Operators - Data could be more informative

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: ameenahsanma(at)gmail(dot)com
Subject: Table 9-40. json and jsonb Operators - Data could be more informative
Date: 2019-10-15 03:53:07
Message-ID: 157111158709.25314.5025115144658634556@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/functions-json.html
Description:

In https://www.postgresql.org/docs/9.4/functions-json.html,

the table 9.40, json and jsonb operators
lists '->>' and '#>>' operators and the difference written is the second one
go to the specific location.

I am not an expert in postgres!
But from my experience,
'#>>' can also parse the data when it is a stringified JSON, having escape
charterers in it!

for ex :
for a scalar value in jsonb : "{\"attr\":\"value\"}", from which we cannot
read keys or values as such,

Query : select (column #>> '{}') from table;
will give parsed json : {"attr" : "value"} from which keys and values can be
extracted.

please mention is there if it is right, as i struggled a lot to figure it
out!

PS: pardon my language, and my concern if it is not right!

Thank you!

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Emil Iggland 2019-10-15 09:56:38 Update documentation - include supported windows version for release 12
Previous Message Tom Lane 2019-10-14 17:59:30 Re: pg error question