jakob / jakob/Postico

Display of numeric fields truncates trailing decimal 0s

Open
#579 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
486
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Postico truncates trailing decimal 0s when displaying numeric fields. This is misleading when dealing with fixed-precision data (like money), and it causes values not to line up when there are multiple rows.

Appears to be the same issue as #205.

Thanks for taking a look!

```psql
SELECT 1.00::numeric, 15.010::numeric;
```

Expected (`psql`'s result):

```
numeric | numeric
---------+---------
1.00 | 15.010
```

Actual (Postico's result):

screen shot 2018-07-26 at 10 57 00 am

---

Postico version:
Version 1.4.2 (2845)

macOS version:
10.13.6

PostgreSQL version:
9.6.9

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the reported query in Postico and compare its numeric display with the shown psql output. Investigate how numeric fields are rendered, preserving trailing decimal zeros and column alignment; done means values such as 1.00 and 15.010 display with their original precision.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases, desktop
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.