Use or not record count on examples
От | Marcos Pegoraro |
---|---|
Тема | Use or not record count on examples |
Дата | |
Msg-id | CAB-JLwYaauh-QRjnqN-DLfgZ8xFmy_uyGe545tiuejtiX0-T+Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Use or not record count on examples
Re: Use or not record count on examples |
Список | pgsql-hackers |
There is no rule of when the number of records at the end of the lists should be shown or not
Sometimes we show that line "(4 rows)", but sometimes not.
Should we have a standard for it ? Should we add them all or remove them all ?
I think they are useless. Or maybe shown when no rows are returned.
datatype.sgml
a | char_length
------+-------------
ok | 2
------+-------------
ok | 2
name | current_mood
------+--------------
Moe | happy
(1 row)
------+--------------
Moe | happy
(1 row)
func.sgml
a | b
---+-----
1 | foo
2 |
---+-----
1 | foo
2 |
make | model | sales
-------+-------+-------
Foo | GT | 10
Foo | Tour | 20
Bar | City | 15
Bar | Sport | 5
(4 rows)
-------+-------+-------
Foo | GT | 10
Foo | Tour | 20
Bar | City | 15
Bar | Sport | 5
(4 rows)
Or maybe when not all records are shown, like in planstats.sgml
index | values | nulls | frequency | base_frequency
-------+----------+-------+-----------+----------------
0 | {0, 0} | {f,f} | 0.01 | 0.0001
1 | {1, 1} | {f,f} | 0.01 | 0.0001
...
49 | {49, 49} | {f,f} | 0.01 | 0.0001
50 | {50, 50} | {f,f} | 0.01 | 0.0001
...
97 | {97, 97} | {f,f} | 0.01 | 0.0001
98 | {98, 98} | {f,f} | 0.01 | 0.0001
99 | {99, 99} | {f,f} | 0.01 | 0.0001
(100 rows)
-------+----------+-------+-----------+----------------
0 | {0, 0} | {f,f} | 0.01 | 0.0001
1 | {1, 1} | {f,f} | 0.01 | 0.0001
...
49 | {49, 49} | {f,f} | 0.01 | 0.0001
50 | {50, 50} | {f,f} | 0.01 | 0.0001
...
97 | {97, 97} | {f,f} | 0.01 | 0.0001
98 | {98, 98} | {f,f} | 0.01 | 0.0001
99 | {99, 99} | {f,f} | 0.01 | 0.0001
(100 rows)
regards
Marcos
В списке pgsql-hackers по дате отправления: