Re: [HACKERS] interval precision oddness

2011-07-12 Thread Tom Lane
Peter Eisentraut writes: > When you create a column with a plain "interval" column, the typmod is > set to -1 and the information schema reports this as 6, because that's > what the internal default value is (see _pg_datetime_precision > function). But when you create a column such as "interval y

[HACKERS] interval precision oddness

2011-07-12 Thread Peter Eisentraut
When you create a column with a plain "interval" column, the typmod is set to -1 and the information schema reports this as 6, because that's what the internal default value is (see _pg_datetime_precision function). But when you create a column such as "interval year to month"), the typmod is actu