| From: | petere(at)postgresql(dot)org (Peter Eisentraut) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Correct/improve the datetime_precision field in the information |
| Date: | 2009-06-10 07:03:34 |
| Message-ID: | 20090610070334.D91DF75331E@cvs.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Log Message:
-----------
Correct/improve the datetime_precision field in the information schema.
In particular, always show 0 for the date type instead of null, and show
6 (the default) for time, timestamp, and interval without a declared
precision. This is now in fuller conformance with the SQL standard.
Also clarify the documentation about this.
discovered and analyzed by Konstantin Izmailov and Tom Lane
Modified Files:
--------------
pgsql/doc/src/sgml:
information_schema.sgml (r1.38 -> r1.39)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/information_schema.sgml?r1=1.38&r2=1.39)
pgsql/src/backend/catalog:
information_schema.sql (r1.53 -> r1.54)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/information_schema.sql?r1=1.53&r2=1.54)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Andrewd | 2009-06-10 15:11:26 | pgbuildfarm - client-code: typdefs change requested by Bruce Momjian |
| Previous Message | Tom Lane | 2009-06-10 05:05:03 | pgsql: Make handling of INTERVAL DAY TO MINUTE and INTERVAL DAY TO |