| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Christoph Berg <myon(at)debian(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <stark(at)mit(dot)edu>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, thomas(dot)berger(at)1und1(dot)de, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_size_pretty, SHOW, and spaces |
| Date: | 2016-08-01 18:53:28 |
| Message-ID: | f3e021d3-d843-04a5-d816-6921309b3bf1@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On 8/1/16 7:35 AM, Christoph Berg wrote:
> PostgreSQL uses the spaces inconsistently, though. pg_size_pretty uses spaces:
>
> # select pg_size_pretty((2^20)::bigint);
> pg_size_pretty
> ────────────────
> 1024 kB
because it's "pretty" :)
> SHOW does not:
>
> # show work_mem;
> work_mem
> ──────────
> 1MB
The original idea might have been to allow that value to be passed back
into the settings system, without having to quote the space. I'm not
sure, but I think changing that might cause some annoyance.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim Gündüz | 2016-08-01 21:23:53 | Re: BUG #14272: baseurl is wrong in pgdg-96-redhat.repo |
| Previous Message | Bruce Momjian | 2016-08-01 18:52:23 | Re: [BUGS] BUG #14244: wrong suffix for pg_size_pretty() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2016-08-01 19:03:08 | Re: New version numbering practices |
| Previous Message | Bruce Momjian | 2016-08-01 18:52:23 | Re: [BUGS] BUG #14244: wrong suffix for pg_size_pretty() |