| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | cbalmeida(at)gmail(dot)com |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #12989: pg_size_pretty with negative values |
| Date: | 2015-04-06 17:45:41 |
| Message-ID: | CAKFQuwYA8qL32EChKxQWrV5eYTPsC0CbJrAOXuUYM3seqvdYuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Mon, Apr 6, 2015 at 10:30 AM, <cbalmeida(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 12989
> Logged by: Christian Almeida
> Email address: cbalmeida(at)gmail(dot)com
> PostgreSQL version: 9.3.6
> Operating system: Ubuntu 14.04 LTS
> Description:
>
> The function "pg_size_pretty" is not formatting negative numbers.
>
>
> Example:
> select pg_size_pretty(+123456789::bigint),
> pg_size_pretty(-123456789::bigint)
>
> Output:
> ----------------------------
> 118 MB -123456789 bytes
>
>
Do you want the result to be "-118 MB" or "ERROR: invalid input - size
cannot be negative (-123456789)"?
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Almeida | 2015-04-06 17:54:52 | Re: BUG #12989: pg_size_pretty with negative values |
| Previous Message | cbalmeida | 2015-04-06 17:30:26 | BUG #12989: pg_size_pretty with negative values |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-04-06 17:51:56 | Re: pg_dump / copy bugs with "big lines" ? |
| Previous Message | Jim Nasby | 2015-04-06 17:31:56 | Re: Freeze avoidance of very large table. |