On 7/17/16 at 11:57 PM, Melvin Davidson melvin6925-at-yahoo.com wrote:
>I'm pretty sure it would be more helpful if you provided:A. The
>structure of the table(s) involved.B. The actual query you used to
>retrieve the data.C. Did you run the query in PgAdmin Query Tool or
>psql ? Melvin Davidson I reserve the right to fantasize. Whether or
>not you wish to share my fantasy is entirely up to you.
No need for fantasy, so nothing to share.
I thought I was providing a simple report of a display bug in a
beta release product with sufficient evidence to prove there is
a problem and nothing more. I am trusting such bug reports are
welcome on this list. Otherwise please let me know where I
should be posting.
While I'm not sure how additional information would be helpful,
since no additional information changes the discrepancy between
the data type and its display, I am answering the questions:
The pgAdmin 4 screen shot snippet showed the "amount" column as
"numeric(12,3)" and the tabulated data below this header has
only two decimal places. The pgAdmin 4 query: SELECT * FROM accounts.transactions WHERE transaction_ref=1506
ORDER BY transaction_ref,transaction_line
The psql screen shot snippet showed the underlying data does
have some non-zero digits in the third decimal place. ANd psql
displays the data to thee decimal places as per data type definition. The psql query: SELECT * FROM
accounts.transactionsWHERE transaction_ref=1506;
The table definition: CREATE TABLE accounts.transactions ( tax_code character(1) COLLATE
"default".pg_catalogNOT NULL, transaction_ref integer NOT NULL, transaction_line integer NOT NULL,
account_itemchar_short_key COLLATE
"default".pg_catalog NOT NULL, amount numeric(12, 3), job char_short_key COLLATE "default".pg_catalog NOT
NULL DEFAULT 0, transaction_memo text COLLATE "default".pg_catalog
DEFAULT ''::text, alt_ledger character(6) COLLATE "default".pg_catalog, CONSTRAINT transactions_pkey
PRIMARYKEY
(transaction_line, transaction_ref), CONSTRAINT transactions_account_item_fkey FOREIGN KEY (account_item)
REFERENCES accounts.account_items (account_item)
MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT, CONSTRAINT transactions_alt_ledger_fkey
FOREIGNKEY (alt_ledger) REFERENCES accounts.ledgers (ledger) MATCH SIMPLE ON UPDATE CASCADE
ON DELETE RESTRICT DEFERRABLE, CONSTRAINT transactions_job_fkey FOREIGN KEY (job)
REFERENCESaccounts.jobs (job) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT,
CONSTRAINTtransactions_ref_fkey FOREIGN KEY (transaction_ref) REFERENCES accounts.transaction_refs
(transaction_ref) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION DEFERRABLE
INITIALLYDEFERRED, CONSTRAINT transactions_tax_code_fkey FOREIGN KEY (tax_code) REFERENCES
accounts.taxcodes(tax_code) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT ) WITH (
OIDS = FALSE ) TABLESPACE pg_default;
Regards
Gavan Schneider