Maximum length of Json value in postgresql 10

Question

Suppose I have the following data

WITH test(id, data) AS (
  VALUES
    (1, '{"key1": "Some text"}'::jsonb),
    (2, '{"other_key": "Some longer text"}'::jsonb),
    (3, '{"key_3": "Short"}'::jsonb)
)
select ??? from test;

Note that the JSON data is simple key-value data. The key can be anything, the value is always a String.

I want to return the maximum number of characters of the value field. 16 in this case, select length('Some longer text');

user330315 · Accepted Answer · 2018-02-28 11:58:54Z

3

You need to turn the values into a set, then you can operate on it:

WITH test(id, data) AS (
  VALUES
    (1, '{"key1": "Some text"}'::jsonb),
    (2, '{"other_key": "Some longer text"}'::jsonb),
    (3, '{"key_3": "Short"}'::jsonb)
)
select max(length(t.val))
from test, jsonb_each_text(data) as t(k,val);

answered Feb 28, 2018 at 11:58

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Maximum length of Json value in postgresql 10

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related