INTERVAL documentation bug?
От | Sebastien FLAESCH |
---|---|
Тема | INTERVAL documentation bug? |
Дата | |
Msg-id | 4A54AFE6.5010106@4js.com обсуждение исходный текст |
Ответы |
Client only install
Re: INTERVAL documentation bug? |
Список | pgsql-general |
I believe the documentation (Data Types section) is missing one INTERVAL "field": HOUR TO SECOND http://www.postgresql.org/docs/8.4/static/datatype-datetime.html The interval type has an additional option, which is to restrict the set of stored fields by writing one of these phrases: YEAR MONTH DAY HOUR MINUTE SECOND YEAR TO MONTH DAY TO HOUR DAY TO MINUTE DAY TO SECOND HOUR TO MINUTE MINUTE TO SECOND It's actually supported: test1=> create table tab1 ( iv interval hour to second ); CREATE TABLE test1=> insert into tab1 values ( 'PT444H59M59S' ); INSERT 0 1 test1=> select * from tab1; iv ----------- 444:59:59 (1 row) Seb
В списке pgsql-general по дате отправления: