Re: Use or not record count on examples

Em dom., 24 de nov. de 2024 às 18:54, David Rowley <dgrowleyml(at)gmail(dot)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