Re: Seconds precision in timestamp columns

"Luiz E. P. Fernandes" <lepfer(at)uol(dot)com(dot)br> writes:
> In the dvdrental example database, there is a column named
> 'payment_date' on the 'payment' table and columns 'rental_date' and
> 'return_date' on the 'rental' table.  These columns appear on the
> information_schema.columns view with identical specifications: datatype
> = 'timestamp without timezone', datetime_precision = 6. However, a
> select on table 'payment' presents column 'payment_date' with 6
> fractional digits, while a select on table 'rental' presents columns
> 'rental_date' and 'return_date' without fractional digits.

Presumably this is just an artifact of the example data. timestamptz_out
suppresses trailing fractional zeroes, regardless of the column's nominal
precision. So there's no reason to think that one column is being treated
differently from the others.

regards, tom lane