diff options
| author | Robert Haas <rhaas@postgresql.org> | 2012-04-14 08:04:11 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2012-04-14 08:07:25 -0400 |
| commit | 4a2d7ad76f5f275ef2d6a57e1a61d5bf756349e8 (patch) | |
| tree | 95875b3c3bf1facfce84e317a863ce8aaf57da81 /doc/src | |
| parent | d4db16d303b24ba5c9a6ddf8c2d70f6fd2da36d7 (diff) | |
| download | postgresql-4a2d7ad76f5f275ef2d6a57e1a61d5bf756349e8.tar.gz postgresql-4a2d7ad76f5f275ef2d6a57e1a61d5bf756349e8.zip | |
pg_size_pretty(numeric)
The output of the new pg_xlog_location_diff function is of type numeric,
since it could theoretically overflow an int8 due to signedness; this
provides a convenient way to format such values.
Fujii Masao, with some beautification by me.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 29d907ddd17..82bac4d6641 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -14981,7 +14981,20 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); <literal><function>pg_size_pretty(<type>bigint</type>)</function></literal> </entry> <entry><type>text</type></entry> - <entry>Converts a size in bytes into a human-readable format with size units</entry> + <entry> + Converts a size in bytes expressed as a 64-bit integer into a + human-readable format with size units + </entry> + </row> + <row> + <entry> + <literal><function>pg_size_pretty(<type>numeric</type>)</function></literal> + </entry> + <entry><type>text</type></entry> + <entry> + Converts a size in bytes expressed as a numeric value into a + human-readable format with size units + </entry> </row> <row> <entry> |