projects / users / simon / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 69ad935) | patch
Correct/improve the datetime_precision field in the information schema.
authorPeter Eisentraut <peter_e@gmx.net>
Wed, 10 Jun 2009 07:03:34 +0000 (07:03 +0000)
committerPeter Eisentraut <peter_e@gmx.net>
Wed, 10 Jun 2009 07:03:34 +0000 (07:03 +0000)
commit4c62779131cb73620dd391ad6dd767ab37fd0d5f
treeac0c77fbe019a798b581ec542e973871e5b8a223tree
parent69ad935ca3ed0fc59d26d6bb9b087c3478982ac5commit | diff
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
doc/src/sgml/information_schema.sgml diff | blob | blame | history
src/backend/catalog/information_schema.sql diff | blob | blame | history
Simon's dev repository