pgsql: Clean up the ancient decision to show only two fractional-seconds

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Clean up the ancient decision to show only two fractional-seconds
Date: 2008-11-12 01:36:20
Message-ID: 20081112013620.21C037545A4@cvs.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Clean up the ancient decision to show only two fractional-seconds digits
in "postgres_verbose" intervalstyle, and the equally arbitrary decision to
show at least two fractional-seconds digits in most other datetime display
styles. This results in some minor changes in the expected regression test
outputs.

Also, coalesce a lot of repetitive code in datetime.c into subroutines,
for clarity and ease of maintenance. In particular this roughly halves
the number of #ifdef HAVE_INT64_TIMESTAMP segments.

Ron Mayer, with some additional kibitzing from Tom Lane

Modified Files:
--------------
pgsql/src/backend/utils/adt:
datetime.c (r1.198 -> r1.199)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c?r1=1.198&r2=1.199)
pgsql/src/test/regress/expected:
horology.out (r1.68 -> r1.69)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/horology.out?r1=1.68&r2=1.69)
interval.out (r1.25 -> r1.26)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/interval.out?r1=1.25&r2=1.26)
timestamp.out (r1.38 -> r1.39)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamp.out?r1=1.38&r2=1.39)
timestamptz.out (r1.32 -> r1.33)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamptz.out?r1=1.32&r2=1.33)
pgsql/src/test/regress/sql:
interval.sql (r1.17 -> r1.18)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/interval.sql?r1=1.17&r2=1.18)

Browse pgsql-committers by date

  From Date Subject
Next Message User Achernow 2008-11-12 04:49:12 libpqtypes - libpqtypes: Made PQtypesRegister a function to hide
Previous Message Andrew Dunstan 2008-11-12 00:01:18 pgsql: Detect and error out on inability to get proper linkage