"Luiz E. P. Fernandes" <lepfer@uol.com.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