• Peter Eisentraut's avatar
    Correct/improve the datetime_precision field in the information schema. · 208d3a75
    Peter Eisentraut authored
    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
    208d3a75
information_schema.sgml 173 KB