Re: Use or not record count on examples

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: Use or not record count on examples
Дата
Msg-id CAB-JLwaao5wseQDy9YHRd8W7V7CXqWpw9_3HAUJjH_n40TXB1g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Use or not record count on examples  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: Use or not record count on examples
Список pgsql-hackers
Em dom., 24 de nov. de 2024 às 18:54, David Rowley <dgrowleyml@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)

В списке pgsql-hackers по дате отправления: