Index: doc/src/sgml/datatype.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v retrieving revision 1.163 diff -c -c -r1.163 datatype.sgml *** doc/src/sgml/datatype.sgml 22 Oct 2005 19:33:57 -0000 1.163 --- doc/src/sgml/datatype.sgml 22 Dec 2005 21:44:08 -0000 *************** *** 1841,1849 **** ! The optional precision ! p should be between 0 and 6, and ! defaults to the precision of the input literal. --- 1841,1860 ---- ! The optional subsecond precision p should ! be between 0 and 6, and defaults to the precision of the input literal. ! ! ! ! Internally interval values are stored as months, days, ! and seconds. This is done because the number of days in a month ! varies, and a day can have 23 or 25 hours if a daylight savings ! time adjustment is involved. Because intervals are usually created ! from constant strings or timestamp subtraction, this ! storage method works well in most cases. Functions ! justify_days and justify_hours are ! available for adjusting days and hours that overflow their normal ! periods. *************** *** 1936,1942 **** CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP. The latter four accept an ! optional precision specification. (See .) Note however that these are SQL functions and are not recognized as data input strings. --- 1947,1953 ---- CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP. The latter four accept an ! optional subsecond precision specification. (See .) Note however that these are SQL functions and are not recognized as data input strings.