]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5cca35a) | 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)
commit208d3a7555541383aadf682e47c14fed21468374
tree01ac99ca659c11bd34b281fd285d45b8749965f3tree | snapshot
parent5cca35a68b63c00d6a7b5d68868f809163929087commit | 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 | history
src/backend/catalog/information_schema.sql diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.