Clarify: default precision on timestamps is 6 - Mailing list pgsql-docs

From David G. Johnston
Subject Clarify: default precision on timestamps is 6
Date
Msg-id CAKFQuwb5hbSCy_zspr_MqqoE-k6MaGt47j1QBFNY-pn9Px8Zqw@mail.gmail.com
Whole thread Raw
In response to Clarify: default precision on timestamps is 6  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: Clarify: default precision on timestamps is 6
Re: Clarify: default precision on timestamps is 6
List pgsql-docs
On Friday, October 13, 2023, PG Doc comments form <noreply@postgresql.org> wrote:
both of them round any precision
beyond microseconds, and neither returns timestamps with greater precision
than the value that was inserted.

That is precisely what a no default with maximum of six means.  If we say the default is six that would imply storage of less precise values pads significant zeros until there are six.

David J.
 

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Clarify: default precision on timestamps is 6
Next
From: Nathan Long
Date:
Subject: Re: Clarify: default precision on timestamps is 6