Greg Sabino Mullane wrote: > I was looking over the "FIXME" marks within the > information_schema.sql, and the last ones left (after my previous > patch) are for interval_type and interval_precision. It looks to me > as if the standard is differentiating between datetime_precision and > interval_precision (see attached patch), so I pulled those apart (for > one view). Does anyone know what is supposed to go into the > interval_type field?
INTERVAL_TYPE IN ( 'YEAR', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'SECOND', 'YEAR TO MONTH', 'DAY TO HOUR', 'DAY TO MINUTE', 'DAY TO SECOND', 'HOUR TO MINUTE', 'HOUR TO SECOND', 'MINUTE TO SECOND' ) Also, depending on which one of these is specified, the precision field varies in meaning. I haven't done a complete analysis, but it might not be as simple as your patch suggests. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
