Em dom., 24 de nov. de 2024 às 18:54, David Rowley <dgrowle...@gmail.com>
escreveu:
> > SELECT format('|%10s|', 'foo');
This example you said returns one value, so I think it is ok.
I'm talking about lists with multiple fields or multiple lines. In [1] we
have both modes.
I don't think that "(2 rows)" is useful
select jsonb_path_query(:'json', 'strict $.**.HR');
jsonb_path_query
------------------
73
135
select jsonb_path_query(:'json', 'lax $.track.segments[*].location ?(@[*] >
15)');
jsonb_path_query
------------------
47.763
47.706
(2 rows)
[1]
https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-STRICT-AND-LAX-MODES
