From 4a2d7ad76f5f275ef2d6a57e1a61d5bf756349e8 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Sat, 14 Apr 2012 08:04:11 -0400 Subject: 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. --- doc/src/sgml/func.sgml | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'doc/src') 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()); pg_size_pretty(bigint) text - Converts a size in bytes into a human-readable format with size units + + Converts a size in bytes expressed as a 64-bit integer into a + human-readable format with size units + + + + + pg_size_pretty(numeric) + + text + + Converts a size in bytes expressed as a numeric value into a + human-readable format with size units + -- cgit v1.2.3